I have a query that checks for some value in field that is not NULL or blank
(field IS NOT NULL OR field <> '')

This seems to really slow the query down and I run several in a loop so it
really adds up.  Is there some other method to check if some value exists in
the field other than NULL or blank??  The DB is MSSQL and the field is a
varchar.

Thanks,Adrian

------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Reply via email to