468,544 Members | 1,815 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,544 developers. It's quick & easy.

Returning data with a max text length

2
Hi,
I wish to return only the data where the 'name' field (text) is 27 characters or less.
I've searched but cannot find a solution.

objRS.Open "SELECT * FROM products WHERE (notes<>'' AND available='' And image<>'default.gif') AND (catcode=18 or catcode=16 or catcode=35)"

This is obviously returning everything, can I amend it to only return the records where 'name' is 27 characters or less?

Thanks in advance.
Mar 15 '10 #1

✓ answered by GazMathias

This is a database question, not an ASP question.

Regardless, investigate the Len() function or its equivalent for whatever database you are using, since you do not say.

Gaz.

1 1369
GazMathias
200 Expert 100+
This is a database question, not an ASP question.

Regardless, investigate the Len() function or its equivalent for whatever database you are using, since you do not say.

Gaz.
Mar 15 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by J Lake | last post: by
1 post views Thread by Randy | last post: by
2 posts views Thread by Dustin Brisebois via DotNetMonster.com | last post: by
7 posts views Thread by Guy Davidson | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.