Depends on whether you have Set Ansi ON or OFF

CLEAR

CREATE CURSOR Dummy (name c(10))

INSERT INTO Dummy VALUES ("Tommy")

SET ANSI OFF

SELECT * FROM Dummy WHERE name="Tom" INTO CURSOR result

?"With ANSI",SET("Ansi"),_tally && shows 1

SET ANSI ON

SELECT * FROM Dummy WHERE name="Tom" INTO CURSOR result

?"With ANSI",SET("Ansi"),_tally && shows 0

Dave

-----Original Message-----

From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Lew Schwartz

Sent: 30 June 2014 16:52

To: ProFox Email List

Subject: Column Width in an Age of Varchar

Is the accepted wisdom for locates, seeks, replaces, ect... now

padr(cExpression, fsize(cFieldName))

as opposed to using len() above, as I think many of us did previously

??

-Lew Schwartz

--- StripMime Report -- processed MIME parts --- multipart/alternative

text/plain (text body -- kept)

text/html

---

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/18725B8CD2D5D247873A2BAF401D4AB22A5223E0@EX2010-A-FPL.FPL.LOCAL

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.