Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > Re: How to find...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 6 Topic 10983 of 11517
 Post > Topic >>

Re: How to find records with length greater than 17

by "Plamen Ratchev" <Plamen@[EMAIL PROTECTED] > Apr 21, 2008 at 03:36 PM

The LEN function returns the number of characters excluding trailing
blanks:

SELECT namecol
FROM Foo
WHERE LEN(namecol) > 17;

The DATALENGTH function returns the number of bytes.

HTH,

Plamen Ratchev
http://www.SQLStudio.com




 6 Posts in Topic:
How to find records with length greater than 17
 ciojr@[EMAIL PROTECTED]   2008-04-21 12:07:07 
Re: How to find records with length greater than 17
 "Plamen Ratchev"  2008-04-21 15:36:18 
Re: How to find records with length greater than 17
 "John Sheppard"  2008-04-22 16:23:33 
Re: How to find records with length greater than 17
 "Plamen Ratchev"  2008-04-22 08:34:56 
Re: How to find records with length greater than 17
 ciojr@[EMAIL PROTECTED]   2008-04-22 09:15:08 
Re: How to find records with length greater than 17
 Gert-Jan Strik <sorry@  2008-04-23 18:46:03 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup
Contact
tan12V112 Wed Dec 3 1:09:38 CST 2008.