I have a column named "ppl". How do I make a constraint for this column that the data inserted got to have 5 characters and start with "ppl" (the next 2 characters got to be numbers)
I tried using CHECK
but I don't know how to and not sure if it works (I'm new to SQL)