By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE data_base (
name VARCHAR (25),
id int,
birthday date);
insert into data_base values
('John', 482, '2000-7-9'),
('Dennis', 912, '2001-12-9'),
('Mike', 123, '2000-4-1');
3 rows affected
declare @textboxtext VARCHAR(25);
set @textboxtext = '/9'
select *
from data_base
where day(birthday)
LIKE replace(@textboxtext,'/','');
| name | id | birthday |
|---|---|---|
| John | 482 | 2000-07-09 |
| Dennis | 912 | 2001-12-09 |
declare @textboxtext VARCHAR(25);
set @textboxtext = '09/07/2000'
select *
from data_base
where birthday
= convert(date,@textboxtext,103);
| name | id | birthday |
|---|---|---|
| John | 482 | 2000-07-09 |
declare @textboxtext VARCHAR(25);
set @textboxtext = '07/09/2000'
select *
from data_base
where birthday
= convert(date,@textboxtext,101) ;
| name | id | birthday |
|---|---|---|
| John | 482 | 2000-07-09 |