Hello:

I'm debugging some code that won't pick up codes that have
non-numeric characters in them. The code uses the val() function
which returns numeric values from a character expression composed of numbers. Is there an alternative function that I'm missing that will
pick up both numeric and non-numeric codes?. My code is as follows:

With thisform.list1
.boundcolumn = 2
.columncount = 2
.columnwidths = "570,0"
.controlsource = "new_course"
.rowsourcetype = 3

Do case
Case val(right(new_course,4) = 0
.rowsource = "select desc_e, code from studies;
where right(code,5) = '0';
and left(new_course,2) = left(code,2) into cursor course3;
select course3

This works fine but is there is a code with a letter included it will
list in my listbox but won't select.
Any help would be greatly appreciated.
Thank oyu.