>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 ?
This Select is for MS SQL Server. I have no idea how to convert it to Access.
--sb--