MID() function with SQL

Hello,

I need to select, from a sql database, data from a field and use something like I do in MsAccess: "SELECT field1 FROM table WHERE mid(field1, 5, 3) = 'abc' ".

Is it possible?

Tks

RuiA

Use SUBSTRING function:

SELECT field1 FROM table WHERE substring(field1, 5, 3) = 'abc'

or you could use LIKE operator

SELECT field1 FROM table WHERE field1 LIKE '__abc%'

|||

Hello Mike

Now, I think I was lazy, this one was easy!!

Thank you very much!!!

RuiA