Substring headaches

Hi there - looks like based on what you're trying to do you may benefit from using 2 more tables in your database. Specifically - you could build these tables: ware & profileware ware should have an ID and a VARCHAR field for the name of…