Basically, although you can do it, you shouldn't. Storing data as comma delimited values in an SQL column is a bad idea - it's hard to work with, it's very hard to edit, and it wastes huge amounts of space.
Instead, create a second table which holds your categories:
ID Description
1 Ex Soldier
2 Senior Citizen
3 Widow
And a third table which correlates those values to your User table:
ID UserID CatID
1 1 1
2 1 2
3 2 3
4 2 2
5 3 1
You then use JOINs to cross correlate the tables.
It may seem more complex to set up - and it is - but it's a lot faster for SQL to process (particularly when you get a serious number of records), it's a lot more space efficient, and it's a lot easier to update and maintain later. It also eliminates the possibility of a user entering "Ex-soldier" instead of "Ex Soldier" and your text based checks failing as a result.