convert string to number(編號：2403)

sql = "select * from XX where number = 123"
that's no problem
but when i using a variable,it's always treat my variable as string
for example
sql = "select * from XX where number =" & _
"'" & in_num & "'"
how to convert in_num to a number