On 15/09/11 10:10 PM, Arturo Perez wrote:
Alternatively, are there any dangers to using likeIgnoreCase if I can be 100% certain that $parm will never contain any SQL wildcards? Seems that query runtime is a little slower that =.
I can't imagine that there would be any measurable difference in the database speed of a LIKE query (with no wildcards) and an = query. You may be over-optimising this bit of code. Perhaps you could run some tests and report back here on the difference. -- --------------------------> Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A
