mid function in ms query

Hello,
i know that the funtion mid works in Excel.
i need to use this function in Ms Query, (get external
data, and edit my query there).
is there any similar function
Thank you
Suhair

Suhair,

Try substr(string,startpostion,length)
eg. substr(mystring, 1, 4)

It's a bit of a shot in the dark but it might work.


"suhair" wrote:

> Hello,
> i know that the funtion mid works in Excel.
> i need to use this function in Ms Query, (get external
> data, and edit my query there).
> is there any similar function
> Thank you
> Suhair
>