Hello everyone

How do I return a partial field value in sql in InterBase?

ie When I use the mid function in an Access query like this:

SELECT Mid([SomeField],1,5) AS Expr1
FROM SomeTable;

if returns the first 5 characters, starting from the beginning of
the value, how do I do the same with InterBase?

Thanks
Mark