I should think before posting. I'll use CASE...
>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.
It's "my" world. You're just living in it.