[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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



>>> 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