General information
Forum:
Microsoft SQL Server
Do not seem to work in Access 2k...
I did :
SELECT FirmID, FirmName, ShortPresentation
FROM Firms
ORDER BY
CASE
WHEN ZipCode = 'J2G 9H8' THEN 6
WHEN ZipCode = LEFT('J2G 9H8',5) THEN 5
WHEN ZipCode = LEFT('J2G 9H8',4) THEN 4
WHEN ZipCode = LEFT('J2G 9H8',3) THEN 3
WHEN ZipCode = LEFT('J2G 9H8',2) THEN 2
WHEN ZipCode = LEFT('J2G 9H8',1) THEN 1
ELSE 0
END
DESC
But I get a Syntax Error.
Any idea ?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only