Search results for query: *

Thanks so much. I have the results I wanted. I appreciate the time you spent to help me. Sally R

Charles, I have solved the original problem by using a combo of my and your code. By using a -1 in the correct place, the field has all characters to the left of the @ sign. See below. Now I am trying to remove spaces from the field created if the last name is less than 5 characters...

Charles, Thanks for your reply. I am getting an SQL execution error. Line 71: Incorrect syntax error near')' when I use the code you suggested. This error is never helpful. Any other thoughts would be greatly appreciated. Thanks. Sallyr CASE...

Please forward the benefit statement report specs. I would love to see them. Thanks so much. Sally

I am trying to successfully execute the following statement. It works except the else(LEFT..). I need to retrieve all the characters from the left of a field until it reaches an @. I do not want to include the @. Any suggestions? Thanks so much. Sally CASE...