SQL Functions CAST , CONVERT not working in Database: Export to data table.

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].[dbo].[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! 😊🔍