Mid() function in SQL, where clause 3

[christer99]

What is the equivalent of a Mid() function in SQL? I need to get this to work.

WHERE Mid(dbo.INS.C, 209,3)='SL '

Obviously this doesn't work because there is no Mid function in SQL, how do I solve this problem? There must be another command?

 

[jbenson001]

Use SubString()

 

[amrita418]

Did you try the substring function?
Sample:

declare    @v_string varchar(20)
set        @v_string = 'getscriptname'
select     substring(@v_string, 4, 6)

Regards,
AA

 

[christer99]

Thanks, that worked.