Hello again,
I'm running Crystal 9 with SQL. I am pulling data from {itemwhse.item}. The subassembly part has an "-" some where in the item and the item can be various lengths. How do I supress the subassembly parts with "-"?
Example:
L7050089
24005389-002
1930015
5011
C1550341-002
Results:
L7050089
1930015
5011
Thanks!
Laurie
I'm running Crystal 9 with SQL. I am pulling data from {itemwhse.item}. The subassembly part has an "-" some where in the item and the item can be various lengths. How do I supress the subassembly parts with "-"?
Example:
L7050089
24005389-002
1930015
5011
C1550341-002
Results:
L7050089
1930015
5011
Thanks!
Laurie