So I have some code that is most of the time a number, but sometimes be a string (i.,e "1000000" or "<1000000").  But I have to compare to a number (i.e, 600000).  The values come from an MS-SQL back end.  I tried using Format() (i.e, Format(rst!.DMSCC.Value, "#########") ) and compare that to...