Help with character count in queries.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

musicfreakcc - 06 Jul 2006 17:06 GMT

How can i remove records in a column that have less than 50 characters or so?

Reply to this Message

John Spencer - 06 Jul 2006 20:33 GMT

Field: FldLength: Len(SomeField)
Criteria: <= 50

> How can i remove records in a column that have less than 50 characters or
> so?

Reply to this Message

MGFoster - 06 Jul 2006 21:11 GMT

> How can i remove records in a column that have less than 50 characters or so?

What do you mean "remove records in a column"? A record (row) contains
columns; a column doesn't contain a record. Do you mean delete a record
(row) that has a column w/ less than 50 characters?

DELETE *
FROM table_name
WHERE Len(column_name) < 50

If you mean set a column value to NULL if it contains a string that is <
50 chars:

UPDATE table_name
SET column_name = NULL
WHERE Len(column_name) < 50

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Reply to this Message