CHARINDEX

[John Justus 4]

Hi,

I wanted to add an additional column to a view with the following calculation

CASE WHEN CHARINDEX('_',[Rec Name]) >=1 then left([Rec Name],CHARINDEX('_',[RecName])-1)

ELSE 'NA'

END Recnew

CHARINDEX is not available in TDV. How can I accomplish

Thanks,

John

[Deepak Kuletha]

Use INSTR function

[John Justus 4]

Thanks. I used the position function and it worked.