Scope With Trailing Spaces

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
G_Ondovchak_(Guest)
Posts: 17
Joined: Tue Oct 10, 2017 12:44 pm

Scope With Trailing Spaces

Post by G_Ondovchak_(Guest) » Wed Sep 10, 2003 3:46 pm

I^ve run into a problem with where I need to specify a scope with trailing spaces. Is this possible and if so how does one do it. For example my master table has a character index with a length of 5. The data contains records with key values of "CP " and "CPMD " and I want a report limited to just key values of "CP ".____TIA____George

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Scope With Trailing Spaces

Post by kfleming » Thu Sep 11, 2003 7:06 am

[updated:LAST EDITED ON Sep-11-03 AT 07:07 AM (EST)]Set the starting scope to CP and the ending scope to CP!__The exclamation point at the end will collate before all alpha/numeric characters and should give you what you need.____Kathleen__R&R Support

Post Reply