Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: SQL Query:TEXT Data Type Operators

    If anyone could help me on this i would really appretiate it.

    It's basically a stupid problem, that i am really not understanding.

    I'm making a query on a table named 'News'
    In this table 2 of the fields i have are:
    date type DATE
    news type TEXT

    I am now making a query, and adding a 3 column.
    On this 3rd column i want to add a few words to the TEXT variable.
    And that's when my problem starts!

    If i had 2 char variables, i could do like 'abc' + 'def' and i would have the result 'abcdef'.

    But how to add a few lines of text to a TEXT data type variable???
    Can't find the solution anywhere. Just a few words on the end of the TEXT variable.

    Basically what i will want after that problem is solved is to convert the data to string and add it to the news TEXT variable.... simple as that.... on every line.

    This should be simple, except i don't know what are the TEXT data type OPERATORS and FUNCTIONS...

    well... i think this is simple now to understand... but in any case I'll be around to explain better anything you need to help me.

    Thanks in advance to all!

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    database systems sometimes have different syntax for dealing with text columns

    for example, some use + for concatenation, some use || (which is the standard), and some even have special syntax, like mysql's concat function

    in this instance i suggest you post your question in (or ask the moderators to move this thread to) the forum which deals with your particular system

    this forum is for non-specific sql | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts