Left and Right Function in Queries

[CBragg]

I have a text field which i need to split in a query. I have just converted the query from 97 to 2000 and im getting an error message saying "Undefined function 'Left' in expression".

The expression i have is:

Test: Left([Field1],4)


Any help would be gratefull, as its doing my head in.


Cheers.

 

[Mile-O]

You'll need to check your libraries.

Search for References - there have been hundreds of posts on this problem.

 

[CBragg]

Cheers for that, it was the Microsoft DOA 3.6 library.