Make snippet case insensitive

Questions and Help
1

How can I make this snippet case insensitive

{formtext: name=boughtby}{dbselect: SELECT Colourway, BookPage, Orders, Buyer, Note FROM Colourways WHERE Orders = yes AND Buyer=@boughtby ORDER BY Colourway ASC LIMIT 900; space=02HdgZGm0jNamFkoQbvhd3; name=search; menu=yes; multiple=no}
{dbupdate: UPDATE Colourways
SET orders="No", buyer=" ",note=""
WHERE Colourway = {=search.colourway}; space=02HdgZGm0jNamFkoQbvhd3; autoaddfields=no}
{=search.colourway} {=search.orders} {=search.buyer}

2

Hi @tonydow.

If you want to make {dbselect} search for the Buyer with a case-insensitive value, you may replace Buyer=@boughtby with lower(Buyer)=lower(@boughtby) as follows:

{formtext: name=boughtby}{dbselect: SELECT Colourway, BookPage, Orders, Buyer, Note FROM Colourways WHERE Orders = yes AND lower(Buyer)=lower(@boughtby) ORDER BY Colourway ASC LIMIT 900; space=02HdgZGm0jNamFkoQbvhd3; name=search; menu=yes; multiple=no}
{dbupdate: UPDATE Colourways
SET orders="No", buyer=" ",note=""
WHERE Colourway = {=search.colourway}; space=02HdgZGm0jNamFkoQbvhd3; autoaddfields=no}
{=search.colourway} {=search.orders} {=search.buyer}

Please let me know if that helps.

3

Thanks Abdalla. Great!