![SQL SERVER - Error: Msg 245 - Conversion failed when converting the varchar value 'Inactive' to data type int - SQL Authority with Pinal Dave SQL SERVER - Error: Msg 245 - Conversion failed when converting the varchar value 'Inactive' to data type int - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/a/case-when-01.jpg)
SQL SERVER - Error: Msg 245 - Conversion failed when converting the varchar value 'Inactive' to data type int - SQL Authority with Pinal Dave
![Code Samples: MySql cast or convert data(integer, float, double, decimal, date, etc...) as character/string Code Samples: MySql cast or convert data(integer, float, double, decimal, date, etc...) as character/string](https://3.bp.blogspot.com/-Mcts2AkBlNQ/Uq5q8K9PgZI/AAAAAAAAAZA/DgC2ncirFmM/w1200-h630-p-k-no-nu/fiddle-13-12-13-11-58.jpg)
Code Samples: MySql cast or convert data(integer, float, double, decimal, date, etc...) as character/string
![sql server - Convert string numeric values with comma as decimal separator to NUMERIC(10, 2) - Database Administrators Stack Exchange sql server - Convert string numeric values with comma as decimal separator to NUMERIC(10, 2) - Database Administrators Stack Exchange](https://i.stack.imgur.com/cgTz5.png)
sql server - Convert string numeric values with comma as decimal separator to NUMERIC(10, 2) - Database Administrators Stack Exchange
![How to convert String to Integer SQL and Database? MySQL, Oracle, SQL server and PostgreSQL Example | Java67 How to convert String to Integer SQL and Database? MySQL, Oracle, SQL server and PostgreSQL Example | Java67](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJnGZ0F1nNh4BVBCqvbZ-nwHbQ_9Y5ezAX-KbN2ypWLkdI2bHN-8FQlE0fPo001uTr0O2AvXyNf_OGa-gZyBZ-gTmW34VGm-GhSvuNZ8g2JVgZiqr19bwSwIeq12naGrFy_KXrKaXtBWtGWjZKn_Wd3D_SxEjsOYG3Pt3K7EtOry6uZoxlnmRbWqeErA/w320-h181/database.png)