How can you convert a string to an integer using an SQL query?

To convert a string to an integer in SQL, you can use the CAST() or CONVERT() functions, depending on your database system.

For example, in MySQL or PostgreSQL, you can use CAST() like this:

SELECT CAST(‘123’ AS INT);

In SQL Server, you can use CONVERT():

SELECT CONVERT(INT, ‘123’);

These functions will convert a string containing numeric characters to an integer. Ensure the string is a valid numeric value; otherwise, the conversion will fail or return an error. Use these functions when performing calculations or comparisons.