Leo,
> So this SHOULD Work then?
AFAIK is the answer on this "No" the "expression" is strange enough a
program language it self, which has nothing to do with the semantic of any
other Net code. Probably is the base for that SQL, which is in my opinion
very much based on local USA standards.
However maybe can you do something by creating first 3 columns in your SQL
Select.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-f
z_2c1f.asp
I hope this helps,
Cor
Leo - 17 May 2005 11:30 GMT
Yeah, I'd rather not assemble the three columns in my SQL as that
starts looking like presentation logic in the data tier, to me anyway,
and I want to try to avoid that. But that may be what I have to do.
Thanks for your help!