You are viewing a single comment's thread from:

RE: LL - Union All - Conversion failed when converting the varchar value to data type int

in #sql3 years ago

Hello,
Did you try a VARCHAR(https://codingsight.com/the-best-sql-varchar-dos-and-donts-for-faster-databases/)? It is one of the most common datatypes and exists in all popular DBMS systems like Oracle, Microsoft SQL Server, PostgreSQL. or can declare VARCHAR columns or variables using VARCHAR[(n)], where n stands for the string size in bytes.