Hi there, please can someone help me with this. I have a VARchar field for NAMES and I need it order numbers correcly and I cant seem to work out the right SQL systax.
My sql is this
SQL = SQL & " Select Distinct" & vbCrLf
SQL = SQL & " galleries.`gal_name`," & vbCrLf
SQL = SQL & " galleries.`gal_group`," & vbCrLf
SQL = SQL & " galleries.`gal_user`," & vbCrLf
SQL = SQL & " galleries.`gal_pw`" & vbCrLf
SQL = SQL & " From" & vbCrLf
SQL = SQL & " galleries galleries" & vbCrLf
SQL_Ext = SQL_Ext & " Order by" & vbCrLf
SQL_Ext = SQL_Ext & " galleries.gal_name Asc" & vbCrLf
SQL_GroupOnly = SQL_GroupOnly & " Order by" & vbCrLf
SQL_GroupOnly = SQL_GroupOnly & " galleries.gal_name Asc" & vbCrLf
This is working FINE BUt it gives me this
Lauras First (1)
Lauras First (10)
Lauras First (11)
Lauras First (2)
Lauras First (3)
Lauras First (4)
Lauras First (5)
Lauras First (6)
Lauras First (7)
Lauras First (8)
Lauras First (9)
WHAT I NEED IS THIS
Lauras First (1)
Lauras First (2)
Lauras First (3)
Lauras First (4)
Lauras First (5)
Lauras First (6)
Lauras First (7)
Lauras First (8)
Lauras First (9)
Lauras First (10)
Lauras First (11)
i know i can use +0 to set the numeric value to a number. But I cant get it right
Can anyone help me please ....
Thanks in advance
Geno