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 |
|
whitmoj
Yak Posting Veteran
68 Posts |
 Posted - 2009-08-27 : 06:07:42
|
| Can any one help me I have a column of data which contains telephone extensions which can contain letters. I am trying to find any extension number with a letter in it. This can be at the start or at the end and in any multiples. Many thanksWhitmojIf I have inspired one person today then my job is done. |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-08-27 : 06:12:45
|
| can u post some sample data and required output? |
 |
|
|
whitmoj
Yak Posting Veteran
68 Posts |
Posted - 2009-08-27 : 06:16:59
|
| here you golll6294lll6271LLL2114LLL2084LLL2080LL818l6995LL6979L6972So example from the above dataSet Column B = '1' Where Column A = 'L%'I have tried all wild cards but they dont seem to workWhitmojIf I have inspired one person today then my job is done. |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-08-27 : 06:18:21
|
| use like instead of = this will solve your problem..iF theRe iS a wAy iN tHen theRe iS a wAy oUt.. |
|
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-08-27 : 06:39:43
|
| use patindex function too.......... |
|
|
|
whitmoj
Yak Posting Veteran
68 Posts |
Posted - 2009-08-27 : 06:48:29
|
| Cheers this worked a treat 90k rows checked and sorted in 5 secsWhitmojIf I have inspired one person today then my job is done. |
|
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-08-27 : 06:58:25
|
| glad to see it solved......iF theRe iS a wAy iN tHen theRe iS a wAy oUt.. |
|
|
|
|
|
|
update issue