substr is a Foxpro command.

This is an excel forum.

Regards,
Tom Ogilvy


"Marc" wrote in message
...
This command is locking up my query. I get an error
saying that the "string cannot be converted into a
number." Anybody shed light?