Convert String to Number

[TornierIT]

Using Crystal 9 and an access database, I am trying to split a field that can contain 1 to many values all separated by a comma. I think need to convert the values in this field to numbers and use it as a select criteria for a subreport

FieldName: Report (String,155)

some examples of values:

9
78,77
13,5,12
61,60,73,72

The field in the subreport is: ReportID(Number)

I knwo it can be done and I think I did it years back, but I cannot find the code for it

 

[TornierIT]

Figured it out..

I just put this in the subreport:

ToText({report.id},"00") in ({?Pm-sqlalert.report})

But if there is a different way, i would like to know