Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - How to convert a string type INTo an int type and multiply it with another int type in SQL?
How to convert a string type INTo an int type and multiply it with another int type in SQL?
Functions with type conversion in SQL:

Cast (field name is int))

For example, your string variable name: myString

INT variable: myInt

You can write it like this

cast(myString as int)*myInt