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 Member Posts: 63
Hi.

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

  • mark baekdalmark baekdal Member Posts: 3
    enclose it in [] IE: select * from tableName where fieldName like '%[%]%'



    regards,
    Mark Baekdal
    http://www.dbghost.com
    http://www.innovartis.co.uk
    +44 (0)208 241 1762
    Database change management for SQL Server



    : Hi.
    :
    : 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.
    :

Sign In or Register to comment.