Converting or getting rid of decimal places 1

[Cpreston]

HI

I have 2 fields both numeric which I want to join together. I have the below line of code

CAST(dbo.Product.Thickness AS varchar) + ' x ' + CAST(dbo.Product.Width AS varchar),

This give me the result of

38.00000000 x 100.00000000

I want it to it is just

38 x 100

How can I get rid of the .0000000 . I have tried a few things I have googled but cannot get it working.

Any ideas please. Many thsnks

 

[kray4660]

One way would be to use Charindex (some might know it as instring). Something like this (not tested)
left(CAST(dbo.Product.Thickness AS varchar), Charindex('.',CAST(dbo.Product.Thickness AS varchar))-1)+ ' x ' + left(CAST(dbo.Product.Width AS varchar), Charindex('.',CAST(dbo.Product.Width AS varchar))-1)

 

[Andrzejek]

How about:
[tt]
CAST(dbo.Product.Thickness As [blue]Int[/blue]) + ' x ' + CAST(dbo.Product.Width As [blue]Int[/blue])
[/tt]

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[kray4660]

Andrzejek : You would need a second cast so that you can to the concatenation;

Cast( CAST(dbo.Product.Thickness As Int) as varchar) + 'x' + cast(CAST(dbo.Product.Width As Int) as varchar)

 

[Cpreston]

Thanks all it is now working. kray4660 did the trick

Many thanks

 

[Andrzejek]

kray4660, you are right.
I've just tried:[tt]
CAST(38.00000000 As Int) [/tt] and that gave me 38, but the over all outcome should be CAST as varchar

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson