I'm pulling a field into a query and need to ignore the first 5 characters of the field. The field may be different lengths, but it's always going to be more than 5 characters and I always need to ignore the first 5.
Is there a trim function that I can use? I'm familiar with TRIM() but I think that only works for leading spaces or zeroes, not what I need.
I know we've got some programmers in here, thought I'd see if anyone can help.