Function List for SQL 2000 1

[Mantle51]

Hi,

I'm trying to create a select statement that determines if a single character in a field(the field is only one character) equals 'M'. I don't see IIF function available in SQL 2000 and I cannot use IF Then syntax in a SELECT statement. So how is this achieved without using a UDF?

Many thanks...........

 

[ESquared]

SELECT
   IsItM = CASE WHEN TheField = 'M' THEN 'YES!' ELSE 'No Way' END,
   *
FROM MyTable

SELECT *
FROM MyTable
WHERE TheField = 'M'

[COLOR=black #d0d0d0]When I walk, I sometimes bump into things. I am closing my eyes so that the room will be empty.[/color]