Hi all
I have an application that has ongoing work done to it so it is hard to pick up exactly what was done to make the following happen.
when comparing a string to a field in a table it is not ignoring blanks for example
I am using sql to select records from table
I have an application that has ongoing work done to it so it is hard to pick up exactly what was done to make the following happen.
when comparing a string to a field in a table it is not ignoring blanks for example
I am using sql to select records from table
Code:
select * from table where alltrim(name) = "abc"[\code]
the above code does pick all names that begin with abc as you would expect but it also picks up blanks.
example 2
i am testnig a date field to see if the date in the field is > than date()-90 it is reuturning .t. on blank
both of the above were working correctly a couple of days ago so i suspect it is a setting, not code
any suggestions are appreciated your help and advice is appreciated