SELECT CAST ( CASE WHEN status = 'A' THEN 1 ELSE 0 END AS bit) AS Rule1
>I have the following SQL Select in VFP application which I need to adopt for SQL Server:
>
>
>select STATUS=A AS RULE1 From MyTable
>
>
>When I pass the above SQL (using SPT) to SQL Server I get error "Incorrect syntax new keyword AS". It must be because SQL Server does not have a logical type and/or it does not support AS.
>
>How can I modify the above SQL Select? RULE1 can have 0 or 1 (not necessarily logical).
>
>Thank you.
--sb--