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 |
|
cnaypi
Starting Member
22 Posts |
 Posted - 2008-05-30 : 16:31:11
|
| I have a column called codeabbreviation and currently the Max character limit is 72. Now I want to decrease it to 35character max but before I do that I want to find all rows in that column that already exceeds the 35character max so that I can clean it up down to 35characters. What is the proper statement to use so that I can query for rows that exceeds 35characters? |
|
|
Sep410
Posting Yak Master
117 Posts |
Posted - 2008-05-30 : 16:44:52
|
| SELECT LastNameFROM TBLName WHERE (LEN(LastName) > 35)Does this help you? |
 |
|
|
cnaypi
Starting Member
22 Posts |
Posted - 2008-05-30 : 16:46:43
|
| Thank you so much. That is what I was looking for. |
|
|
|
|
|
|
character limitation