in a query, how do i delete records that description start w/ "s"

[Guest]

In a query, how do i delete records that the description begin with the
letter "s"?

 

[Guest]

Hi Mystic,

If you really want to delete them, you could use a delete query like this:

delete * from TABLENAME where ucase(left(FIELDNAME, 1)) = "S"

if you just don't want to see them in your query results, just have
something like this:

select * from TABLENAME where ucase(left(FIELDNAME, 1)) <> "S"

Hope that helps.

Damian.

 

[Granny Spitz via AccessMonster.com]

In a query, how do i delete records that the description begin with the
letter "s"?

DELETE *
FROM tablename
WHERE ([description] LIKE "s*");