ASP code SQL syntax for querying fields of the array type in the Access Database

Today, I encountered a problem when modifying a previously developed website. Because of the functional requirements, the previous numeric field was changed to a text field, this field must contain IDs of multiple categories. Previously, this field only corresponds to one ID.

 

Website isASP VBLanguage, the database usesAccess

 

Foreground query after data type modificationCodeYou cannot use conditions such as Xid = 1. Because the field is changed to the text type, its value is in the array format, for example:

1, 2, 3, 4, 5

 

The preceding SQL query statement is:Select [ID] from [Table] Where Xid = 3

 

The corresponding query code should be changed:Select [ID] from [Table] Where ',' + Xid + ', 'like' %, 3, %'

 

Record it to avoid further manual turning.

 

By crazybruce