SQLTeam.com | Weblogs | Forums

Separate column in to multiple column

Hello,

I need help to convert column in to multiple column how can i use in derived column or something..
wanted to use following loging"
hightinfeet: cast(Ieft(heignt,1)*12.00) as decimal (7,3))
hightininch:
(
case isnumeric(replace(right(height, len(height)-2, ' " ', ''))
When 1 then convert (decimal(7,3),replace(right(height,len(height-2), ' " ', ' ' ))
else 0
end
)

eg: height

data
64
511
611
65
Thanks