Help with character count in queries.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can i remove records in a column that have less than 50 characters or so?
 
musicfreakcc said:
How can i remove records in a column that have less than 50 characters or so?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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

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

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRK1uc4echKqOuFEgEQLZiwCfW9lfyu+M2WrFGVilOfASxayLVE0An0sZ
amxS7wmqB5AxDGDbmzbA+q2B
=s5T2
-----END PGP SIGNATURE-----
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Query 2
Pipe character in query in VB6 app 11
Query / Count Length Of Field 3
Please help with access expression 1
Query to count total number of occurences in a range 7
Filling fields in Access with a repeating character 3
Querying for Extended ASCII Characters 1

Back
Top