Originally posted by IGelin You can use Left(), Right(), Mid() VBA functions to manipulate substrings.
Thanks IGelin - I need to use these functions in an SQL statement but it seems that the only option in SQL is LTRIM which is not suitable. Ideally, I would like to be able to write the following:
SELECT left([column],3) FROM [TABLE]. Thanks in advance, Andy