Get string text that starts with J without using the LIKE statement in SQL

Question

Can any one give me an idea about how to filter the name that starts with j without using the Like statement in SQL

Mudassar · Accepted Answer

declare temp table name varchar100insert into tempselect 39John39union allselect 39Jake39union allselect 39Max39union allselect 39Alex39select  from temp where leftname 1  39J39

Get string text that starts with J without using the LIKE statement in SQL

Company

Explore

Follow us

Contact Us