Re: [sqr-users] Substr on SQL in SQR

["Larry Roux" <LRoux@syr.edu>]

I see what you mean now.  Yes.  For numbers it should be where (field1 >= 1 and 
field1 <= 200000000... for the max size of the field. That way you get 1999999.

I was thinking strictly of characters, not numbers.  If the field is a 
character field with numbers in it (character 2 vs number 2) the original code 
should work.  character string '2' is greater than character string '199999999' 
just as 'B' is greater than 'Aardvark'



******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************

>>> WankoC@wyeth.com 11/12/02 02:32PM >>>
>>> LRoux@syr.edu 11/12/02 01:58PM >>>
Then you would only get the row where field1 = 1.  The code as given would give 
values that start with 1.
>>>

I know what you mean, but in SQL that's not what it will do for numbers.  For 
alphanumerics, you're counting on
1,2,3,4,5,6,7,8,9,10,11 being sorted as 1,10,11,2,3,4,5,6,7,8,9.  Or maybe I'm 
confused?

-Chris




_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users