sql query question

I have a Process_ID field where I only want to filter in a view all the starts with 6 or 9 only.
Who is Participating?
NorieConnect With a Mentor VBA ExpertCommented:
You don't say which SQL you are using.

If it's SQL Server you could try using a wildcard/pattern like this.

WHERE Process_ID Like '[6|9]%'
zachvaldezAuthor Commented:
so this syntax left(Process_ID,1)='6' or left(Process_ID,1)='9' can be express shorter in your example?
zachvaldezAuthor Commented:
I agree
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.