I want to ask this.
I want to make a query with a where statement for a field with varchar values.
select * from mytable where myfield like '%post%'
How can I convert post and myfield records all to small (AoA to aoa) or capital (AoA to AOA) letters to this query so fetch all results?