Howdy, this is kind of a continuation of an answer I got from this thread:
My users will enter a city/station where an incident occured, and the date.
The trigger below does work, but it will occasionally put spaces between the
citystation and the date. I think this happens when the citystaion name is not
very long, but not sure.
How can I make sure that if the incidentid is going to have spaces, that sql
deletes those spaces? I need the id to be space free.
TRIGGER [dbo].[tr_AddID1] ON [dbo].[tblIncidents]
View Complete Post