Starr Duskk
asked on
sql query Convert method
This sql statement returns a whole number, like:
1, 7, 14
I want it to return a number like:
1.0.0
7.0.0
14.0.0
How would I alter it? Currently what I've tried gives errors pertaining to it not being an integer value.
thanks!
1, 7, 14
I want it to return a number like:
1.0.0
7.0.0
14.0.0
CONVERT(varchar(10), ISNULL(etw.Listorder, 99)) as 'ListOrder3'
How would I alter it? Currently what I've tried gives errors pertaining to it not being an integer value.
thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER