Quote:If you want to get all the records that start with "R" - set the lower boundary to "R" and the upper to "Rzzzzzzzz".
Mark: Taking the hint from you, I tried to emulate the list display using xuserselectr command. It works fine except one little glitch. "Space" Problem !!!
xUserSelectr commands and functions seems very useful for entering data. It helps to limit the choice when list is very long. So, I decided to work on it taking your hint. The following is the programming I am using...
vStart, vFieldName and vEnd all are string variable.
If @in (vFieldName, "..") > 0 then
{
vStart = @left (vFieldName, @in (vFieldName, "..") - 1)
vEnd = @left (vFieldName, @in (vFieldName, "..") - 1) + "zzzzzzz"
}
Keeping with Sesame and QA tradition, whenever one enters say "blu..", It will make upper and lower limit to be bluzzzzzzz and blu respectively and display all the values starting with "blu". That is all fine.
The problem is the space...
If I place Blue.. in the field, it would not enlist Blue Cross. Does the space has more value than "z"? How to overcome this problem?
Where would we go without your help and input?