Because of a trigger I have installed occasionally a blank alias will be created for an item which sometimes causes issues at POS until I delete it. Is there a SQL statement I could use to perioically purge these blank alias's? Craig
DELETE FROM [Alias] WHERE [Alias] = ''
As always, make sure you back up a database before doing any direct SQL and know that this query is not guaranteed and we are not responsible and yada yada yada, sorry lawyer speak :-)
Thanks Ryan, very much appreciated. Craig
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.