[RESOLVED] How to make a part of this to a variable?

[elmnas]

Hello people

how do I make the number in this code to a variable? (myvar=1)
"741443"

Set rst = conn.Execute("SELECT JobbDK.JOBBNR,JoBBDK.ANM, JobbDK.JOBBESKR FROM JobbDK WHERE (((JobbDK.JOBBNR)=741443));")