>In VFP I could do:
>
>SELECT IIF(EMPTY(field1),field2,field1) AS field...
>
>to pull data conditionally in from either field between two fields in a table. Is there a way to do this in MSSQL? TIA.
You would use CASE function.
SELECT CASE WHEN LEN(field1)=0 THEN field2 ELSE field1 END AS field...
--sb--