DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: inserting the '&' Symbol into a column

  1. #1
    Join Date
    Apr 2003
    Posts
    353

    inserting the '&' Symbol into a column

    Hi,

    I need to insert a columns with
    the below value through sql.

    'TEmCO TRADING & CONTRACTORS'

    As it contains the & symbol, it is not inserting the same,
    but I need that symbol also to be inserted.


    For your information, one of my developer told
    that one of his record is not inserted through asp,
    which contains the 'FOR' in a command column value.

    Any idea how to solve the above two cases?

    Thanks
    Giri

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Code:
    thomas@test> INSERT INTO T3 VALUES ('TEmCO TRADING '||'&'||' CONTRACTORS');
    
    1 row created.
    
    thomas@test> SELECT * FROM T3;
    
    X
    ----------------------------------------
    TEmCO TRADING & CONTRACTORS
    
    1 rows selected.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Code:
    SQL> set define off
    SQL> INSERT INTO T3 VALUES ('TEmCO TRADING & CONTRACTORS');
    
    1 row created.
    
    SQL> SELECT * FROM T3;
    
    C1
    --------------------------------------------------
    TEmCO TRADING & CONTRACTORS
    
    SQL> set define &
    SQL>
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

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


Click Here to Expand Forum to Full Width