By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
declare @opendate varchar(50)
set @opendate = '11111111111'
select @opendate, case when patindex('%[^'+left(@opendate,1)+']%',@opendate) = 0 then 'valid' else 'in valid' end
| (No column name) | (No column name) |
|---|---|
| 11111111111 | valid |
declare @opendate varchar(50)
set @opendate = '21452222'
select @opendate, case when patindex('%[^'+left(@opendate,1)+']%',@opendate) = 0 then 'valid' else 'invalid' end
| (No column name) | (No column name) |
|---|---|
| 21452222 | invalid |