BSSVDBWhereField and Blank

Andrew2009

Well Known Member
I'm doing a database call and there's a String column that can contain blank. I want to exclude those. How do I put blank in the SQL statement please?

new BSSVDBWhereField(IDBService.AND, new BSSVDBField("F11S123.STATUS"), IDBService.NOT_EQUAL, <What should I put in here for blank please?>)
 
Hi Andrew,

I am writing one of my first services and came across the same situation where the data contains blanks and the users want those records excluded.

Did you find an answer for this? Is it two double-quotes?

Derek
 
Back
Top