ike operator with Dataview.RowFilter nor workin

[neeraj]

Hi, all

Could anny one give me help how can I use like operator with these data
types "integer , datetime or boolean" in DataView.RowFilter

Actually when I try to get the data from dataview using rowfilter with
like operator
Its working fine when data type of searching column is "string" .

But if data type is "integer , datetime or boolean" its throws
error

This is the code which works fine

Dim dv As New DataView
dv = dttblFullData.DefaultView
dv.RowFilter = "first_name like 'lilly%'"
dgData.DataSource = dv

And this is not works fine

Dim dv As New DataView
dv = dttblFullData.DefaultView
dv.RowFilter = "Employee_id like '4552%'"
dgData.DataSource = dv

or

Dim dv As New DataView
dv = dttblFullData.DefaultView
dv.RowFilter = "Birth_date like '08/12/2%'"
dgData.DataSource = dv
or

Dim dv As New DataView
dv = dttblFullData.DefaultView
dv.RowFilter = "is_Deleted like 1"
dgData.DataSource = dv
thanks