SQL: Does a Field Exist?

In the FoxPro world, checking to see if a field exists can be done a number of ways: =AFIELDS(la)IF ASCAN(la,”FIELDNAME”)>0 ENDIF or IF TYPE(“FIELDNAME”) = “U” (I’m sure there are lots of other ways especially if you’re already working with a data dictionary tool) In T-SQL, there is no real equivalent however, you can do … Read more