Hi @manicarina,

Here are a few steps you can try:

1. Check Syntax and Data Types:

   • Ensure that the syntax of your SQL query is correct. Double-check the usage of CAST and CONVERT.
   • Verify that the data types you’re converting between are compatible. For example, if you’re converting an integer to a string, use CAST(id AS varchar(200)).

2. String Truncation:

   • If you’re using CAST to truncate strings, make sure that the string_rtruncation database option is set to OFF. Otherwise, you might encounter errors.
   • Alternatively, consider using the LEFT function to truncate strings1.

3. Sample Query:

   • To force integer format, try the following query:

     SELECT CAST(CAST(id AS BIGINT) AS varchar(200)) FROM  Programmer].mdbo].[Diabetic Patient 12 years ove$]
     

Remember to adapt these suggestions to your specific use case. If you encounter any further issues, feel free to ask for more assistance!

Here is the answer goodgist generated for you. Find it helpful ?