Help
in [Programming SQL]
|
Prev: Inserting Excel data into SQL Server
Next: table variable - get the structure from an existing table
From: guru.raks on 15 Jul 2008 05:41 Hi Guys Declare @var varchar(200) SET @var = 'varchar1,varchar10,varchar15' But i want like this @var = varchar,varchar,varchar any one help on this thanks Rakesh
From: Uri Dimant on 15 Jul 2008 05:59 Hi Can you elaborate a little bit on? <guru.raks(a)gmail.com> wrote in message news:062d0cc7-9e05-4fe9-bfb4-42b52f1605f1(a)m44g2000hsc.googlegroups.com... > Hi Guys > > > Declare @var varchar(200) > SET @var = 'varchar1,varchar10,varchar15' > > > But i want like this @var = varchar,varchar,varchar > > any one help on this > > thanks > Rakesh
From: rajdaksha on 15 Jul 2008 06:28 On Jul 15, 2:59 pm, "Uri Dimant" <u...(a)iscar.co.il> wrote: > Hi > Can you elaborate a little bit on? > > <guru.r...(a)gmail.com> wrote in message > > news:062d0cc7-9e05-4fe9-bfb4-42b52f1605f1(a)m44g2000hsc.googlegroups.com... > > > Hi Guys > > > Declare @var varchar(200) > > SET @var = 'varchar1,varchar10,varchar15' > > > But i want like this @var = varchar,varchar,varchar > > > any one help on this > > > thanks > > Rakesh Hi Declare @var varchar(200) SET @var='Datetime15,Datetime1,varchar1,varchar10,varchar15,Numeric10,Numeric1' Above is the string type in @var I want to replace below like this Datetime,Datetime,varchar,varchar,varchar,Numeric,Numeric I want to remove the numeric part in @var Datatime instead of Datetime15 .....
From: Uri Dimant on 15 Jul 2008 06:44
Hi SS2005 only Create a table called Numbers that contains only numbers from 1 to 1000 declare @string varchar(200) set @string = 'Datetime15,Datetime1,varchar1,varchar10,varchar15,Numeric10,Numeric1' select cast(cast((select substring(@string,n,1) from numbers where n <= len(@string) and substring(@string,n,1) like '[a-z ]' for xml path('')) as xml)as varchar(max)) <rajdaksha(a)gmail.com> wrote in message news:00b90715-18de-4256-8ef3-d4d6fdab4320(a)34g2000hsf.googlegroups.com... > On Jul 15, 2:59 pm, "Uri Dimant" <u...(a)iscar.co.il> wrote: >> Hi >> Can you elaborate a little bit on? >> >> <guru.r...(a)gmail.com> wrote in message >> >> news:062d0cc7-9e05-4fe9-bfb4-42b52f1605f1(a)m44g2000hsc.googlegroups.com... >> >> > Hi Guys >> >> > Declare @var varchar(200) >> > SET @var = 'varchar1,varchar10,varchar15' >> >> > But i want like this @var = varchar,varchar,varchar >> >> > any one help on this >> >> > thanks >> > Rakesh > > Hi > > > Declare @var varchar(200) > > SET > @var='Datetime15,Datetime1,varchar1,varchar10,varchar15,Numeric10,Numeric1' > > Above is the string type in @var > > I want to replace below like this > Datetime,Datetime,varchar,varchar,varchar,Numeric,Numeric > > I want to remove the numeric part in @var > > Datatime instead of Datetime15 ..... |