first 5 char = exact match

[aebstract]

I need to limit the results I am grabbing from my query, I need to check if the first 5 characters of the column are equal to 'TYSON'. I know how to do this if it's not "first 5 characters" of the column, anyone shed some light on this? Thanks

[aebstract]

A more 'ghetto' way to do this, which I think will work in my situation, will be to grab all results where that column contains 'TYSON' regardless of position and regardless of first 5 characters. I think that would be easier to grab and I may be able to find a solution.

[Mchl]

At least two ways to do this:

WHERE columnName LIKE 'TYSON%'

WHERE SUBSTR(columnName,1,5) = 'TYSON'

 

[aebstract]

At least two ways to do this:

WHERE columnName LIKE 'TYSON%'

WHERE SUBSTR(columnName,1,5) = 'TYSON'

 

 

Excellent, thanks a lot!