Find any name with a slash "/" in it. 1

[dianemarie]

Hello, what would be the best function to use to find any name in a table that has a slash at the end or beginning of the name? (It's a crude flagging system.) Thank you for any help.

 

[mbarron]

Assuming you are in the selection expert, your formula would be:
(left({your.field},1)="/" or right({your.field},1)="/")

Mike

 

[bdreed35]

Would there be a slash anywhere else in the name?

You could also try:

Inst({table.field},"/") > 0

~Brian

 

[dianemarie]

Worked exactly right. Thank you Mike.