It is basically just the chr(13) that end a line and starts the next like like a line break. You do not see the character but the text editor interprets it start a new line
I suggest it because your select statement is not finding any direct matches so it seems that there is something that is not an exact string match. Maybe an extra space or some other special character (like chr(13))?
{CityStateZipDataset} like "*"+{?CityStateZipParameter}+"*"
should capture everything that
{CityStateZipDataset} = {?CityStateZipParameter})
does and possibly more
YOu could do a little trouble shooting by trying to type in the mathcing records and adding one character at a time and see when it stops working (returning the desired results).
examples:
"Carrollton" works OK
Carrollton," works OK
Carrollton, " works OK
Carrollton, T" stopped working
something is between the ' and the T. maybe an extra space?
YOu can try this as another test in your select options:
replace({CityStateZipDataset},chr(13),"") like "*"+{?CityStateZipParameter}+"*"
Edited by DBlank - 13 Feb 2014 at 4:29am
IP Logged
