Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
viperbyte
Posting Yak Master
132 Posts |
 Posted - 2013-05-31 : 12:20:50
|
| Hi everyone.If I had a table with a column named "Item" and I wanted to see all Items that were longer than six characters, can that be done? If so can someone please show me? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-05-31 : 12:26:18
|
| [code]SELECT Item FROM TABLE WHERE LEN(Item) > 6;[/code]That will ignore trailing spaces when counting the number of characters |
 |
|
|
viperbyte
Posting Yak Master
132 Posts |
Posted - 2013-05-31 : 13:14:34
|
| Thanks a lot. |
|
|
|
|
|
|
Function available?