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
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