jay

Hello,

I'm trying to select some records from an SQL 2000
database. The Select statement is as follows:
select * from test where field1 = '38˚'

No records are retuned even though there are some content
that matches the criteria.

How do I select records that contain the degree '˚' sign?
(I think ASCII code 176)

Thank you for all your help,
Jay

vishal parkar

Jay,

select * from test where field1 = '38˚'
Above query will check exact match for the string 38˚ Hence if you do not have this string
in the column no records will be fetched.
If you want to retrieve rows for a particular column's value that contain ˚ then you will have
to use like operator.

Ex:

select * from test where field1 like '%˚%'

--
- Vishal