how to locate for a blank data

[angelleynes]

I need help on how to locate for a blank data, the field is text datatype...

thanks in advance!

 

[MeanGreen]

Try this:

select <column> from <table>
where <column> like ' '

When dealing with TEXT datatype you use the LIKE statement instead of an equal sign.

Good Luck.

 

[angelleynes]

thanks for your help...