String conversion to numeric

[Randygk]

I have an Item_id field that is a string field I would like to filter off all Item_id's with any characters other than numbers and then change this field to a numeric one so I can sort numerically by item_id.

Thank You,
Randy

 

[Naith]

Randy,

Display some examples of what your id field currently looks like. Using the examples, we can determine if you could use something as simple as a Val() conversion, or whether you require something more.

Naith

 

[Randygk]

I found that the items in question were non stockable items which was another column in the same table so I was able to filter on this column. Thanks