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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-26 : 07:29:44
|
| Les writes "Say I have a field called Department.Is there a way that I can validate on that, but say that I want to know (case insensitive) if the left 7 characters of Department is "PRODUCT" for instance." |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-26 : 07:31:06
|
| Is this?Select columns from yourTable where Department like 'PRODUCT%'MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
validating against sub-field