Prev: About Autonumbering
Next: creating a start and end date table
From: sam on 17 Feb 2010 07:43
Is their is any method or procedure(Logic) to Convert my int input to
String

e.g. if i input Number 1 then output should be One

if 2 then Two and so on
From: Uri Dimant on 17 Feb 2010 08:44
sam
Take a look at CAST and CONVERT system functions in the BOL


"sam" <sumesh.jangra2009(a)gmail.com> wrote in message
news:35eb89d7-b37e-4739-b3a4-ff9f85dfdb08(a)l24g2000prh.googlegroups.com...
> Is their is any method or procedure(Logic) to Convert my int input to
> String
>
> e.g. if i input Number 1 then output should be One
>
> if 2 then Two and so on


From: Plamen Ratchev on 17 Feb 2010 09:57
There is no built-in function, you would have to implement yourself (or simply use a table with two columns to map
numbers to text).

--
Plamen Ratchev
http://www.SQLStudio.com
 | 
Pages: 1
Prev: About Autonumbering
Next: creating a start and end date table