Proper syntax for while select matching multiple characters

(0) Share

Report

Posted on by Community Member

I've got a while select statement where I want to join ProjectIds from one table.

5287.Capture.PNG

My line in question is the highlighted one and I want what is equivalent to the * (or % in sql) to go after the ProjTable.ProjId, but I'm not sure on the syntax.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Martin Dráb 235,792 Most Valuable Professional on at

Like (0)

Report

RE: Proper syntax for while select matching multiple characters

You can filter string values with 'like' operator, but it doesn't make a good sense to me at the highlighted line, because there you're joining tables, not filtering the data.

Was this reply helpful? Yes No