Help with a SQL Expression

Topic

New Reply

I need some help with a SQL Expression:

CASE WHEN dbo.tblOffices.Office = ‘Leicester’ THEN ‘Leicester Office’ END

It just brings an error, what is wrong with it?

Reply | Quote

Replies

Msg 102, Level 15, State 1, Line 1
Naming anomaly near ‘Leicester’ . Should be ‘Leicestershire’.

🙂

Reply | Quote

Luke,
What is the error you are getting? Statement looks OK to me, if you realize that it will return NULL unless ‘Leicester’ is found. You might want to put in an ELSE statement.

Reply | Quote