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

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

Then you would only get the row where field1 = 1.  The code as given would give 
values that start with 1.


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

>>> WankoC@wyeth.com 11/12/02 12:58PM >>>
>>> LRoux@syr.edu 11/01/02 07:30PM >>>
The reason this is happening is that you are forcing a tablescan - and if the 
field is not the primary key you are digging a big hole.
3) better yet, us a double where clause  (where field1 >= '1' and field1 < '2')
>>>

In the last example, wouldn't "where field1 = '1'" be fastest?

-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