Need help with VB script for SQL server

[pyroskliq]

My VB scripting isn't too good, and I'm trying to create a script for a data transformation in SQL server. The field that I'm transforming contains a combination of number and text. All are 4 characters long, such as 1000, 1100, 5000 etc. Some are 19XX or 11DX.

The script I am trying to create will update another field, so that if the record is a number and is between a certain range (such as >=1000 And <=5000 then the field will be an &quot;M&quot; and if the record is anything else (numeric or text) then the field will be an &quot;N&quot;.

Like I said, my scripting is pretty weak, and I'm fighting with the VB scripting users guide. Any help would be appreciated.

Brian

 

[rmadiedo]

If your position is fixed, you may use the Mid$() Function to determine if the field contain characters.
Or you can use the IsNumeric() Function, it will return a boolean indicates true if ALL YOUR CHARACTERS are numeric else return false.
Then you can use the Val() Function that return the numeric value of your character field
Let me know if this help you