How to Concatenate Numbers and Strings to Format Numbers in T-SQL?

by

A couple of quick notes:

  • It’s “length” not “lenght”
  • Table aliases in your query would probably make it a lot more readable

Now onto the problem…

You need to explicitly convert your parameters to VARCHAR before trying to concatenate them. When SQL Server sees @my_int + ‘X’ it thinks you’re trying to add the number “X” to @my_int and it can’t do that. Instead try:

SET @ActualWeightDIMS =
     CAST(@Actual_Dims_Lenght AS VARCHAR(16)) + 'x' +
     CAST(@Actual_Dims_Width  AS VARCHAR(16)) + 'x' +
     CAST(@Actual_Dims_Height  AS VARCHAR(16))

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. SQL Server dynamic PIVOT query?
  3. SQL Server Process Queue Race Condition
  4. Create a date from day month and year with T-SQL
  5. Creating an index on a table variable
  6. SQL – Subtracting a depleting value from rows
  7. OR is not supported with CASE Statement in SQL Server
  8. Parse comma-separated string to make IN List of strings in the Where clause
  9. How to set variable from a SQL query?
  10. SELECT FOR UPDATE with SQL Server
  11. T-SQL: Selecting Column Based on MAX(Other Column)
  12. How to group by month from Date field using sql
  13. SQL dot notation
  14. Split function in SQL Server 2008
  15. T-SQL How to create tables dynamically in stored procedures?
  16. What is the difference between SQL, PL-SQL and T-SQL?
  17. What is the equivalent of ‘describe table’ in SQL Server?
  18. Create a SQL query to retrieve most recent records
  19. Can I set ignore_dup_key on for a primary key?
  20. Unordered results in SQL
  21. Using PIVOT in SQL Server 2008
  22. SQL Server replace, remove all after certain character
  23. Generating random strings with T-SQL
  24. Inserting rows into a table with one IDENTITY column only [duplicate]
  25. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  26. When using GETDATE() in many places, is it better to use a variable?
  27. SQL Server SELECT INTO @variable?
  28. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  29. Select a column if other column is null
  30. Sql Server : How to use an aggregate function like MAX in a WHERE clause

Leave a Comment