Post reply

Ignoring " from Text

  • December 19, 2006 at 8:30 am

    #176060

    Hi all,

    How can i ignore " from the field.

     

    Select comment1, comment2 from test

     

    but i don;t want " from comment1 and comment 2

     

    thanks

     

  • December 19, 2006 at 8:37 am

    #678933

    Check out the REPLACE function in Books Online.  You can replace '"' (double quotes) with '' (an empty string).

    John

  • December 20, 2006 at 8:53 am

    #679143

    Assuming that u have data in comment1 and comment2  like:

     

    ‘Text1”Text2’

     

    do u want:

     

    1)    change the original data to ‘Text1Text2’ and THEN select  the text OR

    2)    not to alter the original string in the table but nevertheless SELECT text ‘Text1”Text2’  as ‘Text1Text2’ from the field(s)  for presentation purposes?

     

    Both 1) and 2) are possible.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply