Re: [sqlite] Problem selecting the empty string in a column

2008-11-19 Thread Brad Stiles
> I am *sure* that I am overlooking the obvious... > > I have a need to identify blank columns in my tables, and have been unable > to find a suitable query, eg > > SELECT * from table WHERE column = ''; > > What am I doing wrong here? It depends on what "blank" means? Does it mean an empty strin

[sqlite] Problem selecting the empty string in a column

2008-11-19 Thread steveo
Hi Folks, I am *sure* that I am overlooking the obvious... I have a need to identify blank columns in my tables, and have been unable to find a suitable query, eg SELECT * from table WHERE column = ''; What am I doing wrong here? TY, Steve ___ sqli