Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - Sql statement, how to convert character type into digital type (integer type, floating point type), what function to use online, etc.
Sql statement, how to convert character type into digital type (integer type, floating point type), what function to use online, etc.
You can try the Convert function, for example:

Convert(int, field)// The first parameter is the target type, and the last parameter is the field name.

If you want to convert to floating point/date, you can control the format through the third parameter.