> > well, i just tried it on oracle 8i as well and it doesn't work there
> > either, so i'm going with the theory that the CF people are just on crack
> >
> > "go back to your homes citizens, nothing to see here"
>
>Isn't left() a Visual Basic thing?
It's also a mysql thing.. don't know about VB..
------------------------
Chris Smith
http://www.squiz.net