>>Why?
>
>There may be functions (with arguments separated by commas) in the select.
>Counting the number of commas would not give the right result
>
>
>select left(field,2) as xx
>
Right. My first idea was also to count number of commas, but then I found there were several functions (ISNULL) in the field list.
If it's not broken, fix it until it is.
My Blog