case when field ='' then NULL
else field
END as field
NULLIF(YourColumn, ' ')
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe