using like condition in Subsonic 2.2

Question

I need some help in using "like" condition in Subsonic 2.2

Following is my query

DAL.DB.Select()
    .From("tblName")
    .Where("NewFirstName")
    .Like(strFirstName)
    .Or("PrevFirstName")
    .Like(strFirstName)
    .ExecuteDataSet();

the result returned by above query contains records those have firstname euqal to strFirstName not like strFirstName

example: there are two records which has NewFirstName as 'joe' and 'joe J' so above query just returns record that has 'joe' as NewFirstName .

A like clause requires that addition of a percent "%" symbol, which represents a wild card. — Zachary, Mar 08 '11 at 01:45

score 2 · Answer 1 · answered Jan 18 '11 at 17:21

2

Did you try this : strFirstName = 'joe*' or strFirstName = 'joe%' ?

answered Jan 18 '11 at 17:21

ykatchou

3,667
1
22
27

score 0 · Answer 2 · answered Jan 18 '11 at 18:32

0

You seem to be misunderstanding how the LIKE operator works.

Perhaps you should peruse the documentation.

answered Jan 18 '11 at 18:32

quentin-starin

26,121
7
68
86

using like condition in Subsonic 2.2

2 Answers2