a billion thanks Teddy! ...as it is said, you're the best...access monkey...if you please.
however just clearify me on the last line "FORMAT() should probably be done at the client".
Now I know I can use VB2005 to create functions in SQLServer and I was thinking of creating @FORMATn(byval n as number, s as string) and @FORMATd(d as date, and s as string) functions in the sql db version.
So in the implementation of the, say @FORMATn(...) I would just return
... format(n, s) and for the other it will be ... format(d, s)