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
getting rid of blank alias's
Jul 27, 2007
2 Replies
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required