Find numeric ? Help needed !

[Stephen Barncard]

Actually there ARE problems with finding numbers formatted 
differently. I just ran into this problem with a database.

If you are searching for "22" in a listing that has a number 
formatted "00022" one has to modify the search terms accordingly, or 
set the numberformat of the search string to match the expected 
format in the list. This method still expects consistency in the 
listing or the search term. I chose the latter of setting the 
numberformat of the search string because my data source, the SQL 
database, had been formatted long ago, in a HC stack. It works 
perfectly now.

At 1:17 PM -0700 6/2/05, Jeanne A. E. DeVoto wrote:
>
>Well, numbers are strings in Transcript - a number in a field is no 
>different from any other string - so there shouldn't be any problem 
>with numbers or any need for a special numeric mode. I agree with 
>the person who asked for an example of a search that is failing.
>--
>jeanne a. e. devoto ~ revolution at jaedworks.com
>http://www.jaedworks.com