sql server - need help in TSQL query that select policy id = 1 -

i want in query selects data having policy_id 1

the query using is

select policy_id policy_dim policy_id '%1';

the problem select data having 1 @ last digit eg 21, 31 ,41

the data in data warehouse policy id

 policy_id  1  01  001  0001

try this:

select policy_id policy_dim cast (policy_id int) = 1;

Employment