dataview rowfilter LIKE * works not exactly
<p>My <code>dataview</code> has 1 column named <code>RecordType</code> (Primary key in SQL, type <code>varchar(18)</code>), which has 3 records {"NH", "NTH", "XH"}.</p>

<p>Now, I want to filter data which starts at "N", by coding: </p>

<p><code>( myDataView.RowFilter = "RecordType LIKE 'N*'")</code>, but just 1 record was returned ({"NTH"}) </p>

<p>Exactly result must has 2 records ({"NH", "NTH"}).</p>

<p>Please how can I correct this?</p>