Seperate The Text

If I had a field which is let's say "123 Abc Street" and I would want to seperate the street number from the street name. I formulated this in excel:

=MID(A1,SEARCH(" ",A1,1)+1,LEN(A1)-SEARCH(" ",A1,1))

Where A1 is the cell...

Is the syntax the same in ASP?

Also I want to use this on a field called "Address" in my database, and then sort by the results of this formula. So could I do something like this:

SELECT * FROM Properties_tbl ORDER BY MID(Address,SEARCH(" ",Address,1)+1,LEN(Address)-SEARCH(" ",Address,1))