Extract data where it begins wiht certain leters
I have for all entries for 5 tables but I need to extract all the data where it begins with certain leters like "ab". how can I define that in my select. Thanks
Satyasuresh Donepudi replied
You can use wild card characters like '%' in Where class,
... WHERE CITY LIKE '%town%'. This condition is true if the column CITY contains a string containing the pattern u2018townu2019. ... WHERE NAME NOT LIKE '_n%'. This condition is true if the column NAME contains a value whose second character is not u2018nu2019.