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-12-15 : 03:06:33
|
| Hi,I have two type of strings in table.Declare @string1 varchar(100)Declare @string2 varchar(100)set @string = 'ALU (A4XHBM1) DFLTGRP(EORGA)'set @string = 'CO (A4XHBM1)'I want the output to beA4XHBM1A4XHBM1Regards,Sachin |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
EXTRACT a specfic part from string