Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
How to retrieve account records where the name starts with "comp"?
Select Id,Name From Account Where Name Like 'comp%'
Does the above query guarantee at least 4 characters in length?
the expression 'comp%' will bring everything that starts with 'comp' and ends with anything
if you want to always guarantee 4 letters after 'comp' you can use it as follows LIKE 'comp____' use 4 underscore to ensure 4 characters after 'comp'
Required, but never shown