mikemireku (10/30/2008)
in Access, you can use the following sql statement to format a number:format(number,"0000") as result
An example of result could be 0023, rather than 23
WHen doing in SQL Server, I am advised that format is not a recognised function. WHat can I do to achieve the same result in SQL Server? Cheers.
Where do you want to show data?
If you use front end application, you can use format function there
Failing to plan is Planning to fail