[SQL] convert to a string

[Shavonne Marietta Wijesinghe]

Hello 

i have a column N_GEN in postgreSql defined as text. In this coloumn i insert a 
number 10

N_GEN (text) = 10


on error resume next
  Set oRs = oConn.Execute("SELECT N_GEN FROM MyTable ORDER BY N_GEN DESC")
  If err <> 0 then 'If table not found
   GetFieldValue = "1"
  else
   GetFieldValue = oRs("N_GEN") + 1
  End If

But it doesn't add the 1 to my N_GEN
How can i set the Recordset to convert the string to a number and then add 1 to 
it??

Shavonne Wijesinghe
http://www.studioform.it