Search comma separated string in Column t-sql
In a property mgt system, I'm saving buyers based on their preferences.
Say a person interested in houses which has more than 2 & less than 4. So
I saved it as 2,3,4. Please see the attachment.
When searching, say someone searching the buyers who are interested in
houses which has more than 2, how should i write the select statement to
check the bedroom column.
If someone search buyers who are interested in houses which has more than
2 bathrooms; what could be the select statement?
No comments:
Post a Comment