Yuriy Martsynovskyy
<[EMAIL PROTECTED]> wrote:
How do I filter out records that contain WHITE SPACE in a field or
have this field empty?
For example:
select * from mytable
where fld <> "" and fld LIKE .
fld <> '' and not (fld LIKE '% %')
-- that's percent space percent
Igor Tandetnik
[EMAIL PROTECTED]>
Date: Friday, August 17, 2007 7:25 am
Subject: [sqlite] Re: like operator
> RaghavendraK 70574
> <[EMAIL PROTECTED]> wrote:
> > we have given a web interface which receive delete request.
> > Now in the req we get "%" and in the delete i
l in error, please notify the sender by phone or email immediately and
delete it!
*
- Original Message -
From: Igor Tandetnik <[EMAIL PROTECTED]>
Date: Friday, August 17, 2007 9:55 am
Subject: [
RaghavendraK 70574
<[EMAIL PROTECTED]> wrote:
we have given a web interface which receive delete request.
Now in the req we get "%" and in the delete impl we do this
delete from table where itemName like xxx.%;
since the key is % the above statement becomes,
"delete from table where itemName lik
4 matches
Mail list logo