Hi! I got syntex error message whe

[gc]

Hi!
I got syntex error message when try to run the code:

SELECT
CASE
WHEN NOT ISNUMERIC(LEFT(MRN,1)) THEN MRN
WHEN NOT ISNUMERIC(LEFT(RIGHT(MRN,2),1)) THEN RIGHT(MRN,2)
ELSE RIGHT(MRN,1)
END AS Code
FROM abo.tblPatients

The error message is: Incorrect syntax near the keyword "THEN" on the second line

Please tell me what's wrong?
Thanks in advance!
George

 

[jhall156]

SQL Server will not evaluate a boolean expression this way.
Try:

SELECT
CASE
WHEN ISNUMERIC(LEFT(MRN,1)) = 0 THEN MRN
WHEN ISNUMERIC(LEFT(RIGHT(MRN,2),1)) = 0 THEN RIGHT(MRN,2)
ELSE RIGHT(MRN,1)
END AS Code
FROM abo.tblPatients JHall

 

[gc]

Hi! J,
Thank you very much!
It's working now.
George