SQL special chars ??? - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

SQL special chars ???

ampoampo Posts: 63Member
Hello.

How can I deal with special chars like '%' ??
I know it is a wild card in SQL, but how can I look for the specific char in a table ?

" select * from tableName where fieldName like '%%%' " ???

any special chars table ?

thanks.

Comments

  • infidelinfidel Posts: 2,900Member
    : Hello.
    :
    : How can I deal with special chars like '%' ??
    : I know it is a wild card in SQL, but how can I look for the specific char in a table ?
    :
    : " select * from tableName where fieldName like '%%%' " ???
    :
    : any special chars table ?

    You need to find out what "escape" character to use for your database. In Oracle9i I do this:

    select * from table where id like 'FOO%' escape '';

    The escape character tells the database that the next character in the value is literal instead of special.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

    [code]
    $ select * from users where clue > 0
    no rows returned
    [/code]

Sign In or Register to comment.