Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to filter a text information?

I've a text SQL table named "Salesman" with the following data:

- John 130 South
- Jack 342 North
- Mike 130 South

How can I list only the fields with '130' in the field?

4 Replies
Not applicable
Author

Try this!!!

=IF(Salesman like '*130*', Salesman )

Not applicable
Author

Hello

This information I insert in Sort tab, Expression?

Thanks

Not applicable
Author

Depends what you want....i used that in dinamic table on expression.....

Not applicable
Author

Try this

if(Subfield(Salesman,' ',2) = 130)