help with SQL query

[NickMalloy]

I am trying to combine two column into one with an added'/' in between the values.

qryHeightWeight2.[Weight (lbs)] + '/' + Convert (decimal(10,2), round([Weight (lbs)]/2.2, 2)) AS totalWgt,

I am receiving an error

Syntax error converting the varchar value '/' to a column of data type int.

How can I accomplish this?

 

[checkai]

ltrim(rtrim(str(qryHeightWeight2.[Weight (lbs)]))) + '/' + ltrim(rtrim(str(Convert (decimal(10,2), round([Weight (lbs)]/2.2, 2))))) AS totalWgt

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."

 

[manjarikosaraju]

select cast[Weight] as varchar(10)) + '/' + cast(Convert (decimal(10,2), round([Weight]/2.2, 2)) as varchar(10))
from qryHeightWeight2

 

[NickMalloy]

checkai, any ideas why the second part would be cutting out the decimal. I need two digits after the decimal?

 

[checkai]

probably the str() function...using convert or cast may work better...

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."

 

[SajidAttar]

Use convert (e.g.)

convert(varchar,qryHeightWeight2.[Weight (lbs)]) + '/' + (convert(varchar,Convert (decimal(10,2), round([Weight (lbs)]/2.2, 2))) AS totalWgt