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 |
|
sachingovekar
Posting Yak Master
101 Posts |
 Posted - 2009-01-23 : 01:46:02
|
Hi,I have data in the following format in one table AFTER EXECUTION SHOULD LOOK LIKE  I want to populate LoginID column by using Col1 and Col2The Login ID is placed randomly in the text.Login ID is in the format AB12345 (first two character and then five integers)The script should first search login ID in Col1, If not found in Col1 the search in Col2, IF FOUND UPDATE LOGINID columnPlease help.Regards,Sachin |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-01-23 : 02:28:02
|
for me, no pictures visible.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Nageswar9
Aged Yak Warrior
600 Posts |
Posted - 2009-01-23 : 03:31:24
|
| can u post ur table Structure and requirement |
|
|
|
|
|
|
Extract LoginID from string