Forums
This topic is locked
update - lowercase
Posted 30 Jun 2002 17:13:19
1
has voted
30 Jun 2002 17:13:19 aegis kleais posted:
if UPDATE tblNPCs
SET fldPortraitDone = 'no'
WHERE fldPortraitDone = 'No'
replaces all instances of No with no, then how can I search for any instance of anything and return it's lowercase equivalent?
Ie, Hello would be changed to hello.
Anyone?