SQL for filtering records with part of value is same -
i don't have expertise in sql. want filter records table below criteria.
i want separate out records in below example result showing "klmnp03" , "uvxyz03". there similar records last chars 03 , 04, want filter out records 03 @ end
for example:
col1 --------- abcde03 abcde04 klmnp03 lmnop03 lmnop04 uvxyz03
i'm not sure use case is, pretty inefficient. it's better use whole columns. in case, asking for:
select * yourtable col1 not ( '%03' )
this return not have 03 @ end.
% wild card character, , represents number of characters before normal characters. can similar _ character, represents single random character.
in sqlserver @ least. may different in other rdbms
Comments
Post a Comment