CharIndex help

[BHScripter]

Hi:

I have a column of data in a table which is basically a log file that contains basically just a dump of values that could be in a variety of orders.

I want to pull 8 characters after the value UCODE = '

which looks like UCODE = 'br24hr02'

I need the br24hr02

It will always be in the string with exactly this spacing for this kind of value but it could be in multiple places within the whole string depending on what it is logging.

Thanks in advance.

 

[simian336]

select Field, charindex( 'UCODE = ''', Field) as Location
, case
when charindex( 'UCODE = ''', Field) = 0 then
''
Else
substring(bla, charindex( 'UCODE = ''', Field)+9, 8)
End as List
from Table


Simi

 

[simian336]

Had a typo...

select Field, charindex( 'UCODE = ''', Field) as Location, case
when charindex( 'UCODE = ''', Field) = 0 then '' Else
substring(Field, charindex( 'UCODE = ''', Field)+9, 8)
End as List
from Table

Simi

 

[BHScripter]

Thanks I will try it!