how to query the first 3 digits of a field

[blogmad]

I'm trying to export from a text file. However one of the fields contains 2 items of data, ie the code and name of a person.
eg 'po2 Paul O Mahony'. What I want to do is query only the code(first 3 digits) from this field. ie 'po2'. Is there a way of doing this within a query (sql) or do I have to use vbscript to solve this?
thanks

 

[raskew]

Hi -

Left([po2], 3)

Oops: Left([your_field_name], 3)

HTH - Bob