xsharp.eu • LIKE()
Page 1 of 1

LIKE()

Posted: Thu Feb 27, 2020 4:20 pm
by kevclark64
The LIKE() function in XSharp appears to be case insensitive whereas in Foxpro it is case sensitive:

Code: Select all

local lValue as Boolean
lValue=LIKE("Cha*","CHARLES")  // False in Foxpro True in Xsharp
As far as I can tell there is no flag or parameter in Foxpro to make LIKE case-insensitive. One would have to use either UPPER() or LOWER() for that.

LIKE()

Posted: Thu Feb 27, 2020 5:27 pm
by Chris
Thanks Kevin, confirmed and logged. Currently in X# you need to use the _Like() function for a case-sensitive comparison (instead of the case-sensitive Like()), but I realize this is different to how it works in VFP.