I know how to use it with MySQL but how do you use the function substring with a variable? Thanks Dallas Freeman