is there a mid() function for stored procedure

[davejam]

Morning all,

As the subject says, i'm trying to select a record (well update in the long term but selecting is a good start) where the 4th value in the string is "1", thought it'd be easy as i've used the mid() function for a while in access but unfortunately this isn't an sql function!!!!

So heres to the question, does anyone know of a mid or middle function for stored procedures?

cheers



daveJam

*two wrongs don't make a right..... but three lefts do!!!!*

 

[vongrunt]

Try substring( myField, 4, 1).