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