declare @s-2 varchar(1000), @data int

I think below statment can use full for yur case

select @s-2 = '600 A & B & C...

Begin Catch

--U can Reaise Error or Sipmly return error message for test

SELECT Error_message()

end Catch

Looking for spcefic reason not alternate solution

try below sql statment with admin permision

update sc

set sc.name=replace(sc.name,' ', '')

from sys.syscolumns sc,sys.sysobjects so

where so.id=sc.id and so.type ='u' and charindex(' ',sc.name)>0

--and so.name='table_name'

You can use the below query to find out the spcae od data file

select * from dbo.sysfiles

or sp_spaceused

I am getting problem parsing the xml using t-sql,

Not getting all node value...

any idea...

My hole xml look like

declare @appro_xml xml

set @appro_xml='

1020

210

1001

24

19

11

12

14

15

1

0

1

1

1

...

t-sql

DeclineReasonCode node

not returning all node value

11,12,13 etc

1020

210

11

12

14

15

xml file

declare @appro_xml xml

set @appro_xml='

1020

210

11

12

14

15

'

result should be p1 ->30 but comming as a 60,I am a not looking for the p3 item

use convert option 107 and do some manuplation for suffixed (st,th etc)

select convert(char(20),getdate(),107)

use old way to get the parent id

CREATE TABLE #my_table (

[menu_id] [NUMERIC](9,0) IDENTITY ( 1 , 1 ) ...

THANKS

according sql statment result

select len(cast('xxx' as char(7))),datalength(cast('xxx' as char(7))),

len(cast('xxx' as varchar(7))),datalength(cast('xxx' as varchar(7)))

char data type store 7 character including space(3+4(space)) , but varchar store ony 3 character only...