1. Home
  2. General
  3. General Chat

SELECT * FROM tblA Where LEFT(filedA,11) = 'TS-20081014'

Posts   
 
    
thel
User
Posts: 2
Joined: 14-Oct-2008
# Posted on: 14-Oct-2008 04:50:42   

Hi All,

I'm a newbie in llblgen. Can anyone help me create the PredicateExpression for where condition

SELECT * FROM tblA Where LEFT(fieldA,11) = 'TS-20081014'

Hope someone will help me. Thanks smile

mihies avatar
mihies
User
Posts: 800
Joined: 29-Jan-2006
# Posted on: 14-Oct-2008 08:46:28   

thel wrote:

Hi All,

I'm a newbie in llblgen. Can anyone help me create the PredicateExpression for where condition

SELECT * FROM tblA Where LEFT(fieldA,11) = 'TS-20081014'

Hope someone will help me. Thanks smile

I guess doing WHERE fieldA LIKE ''TS-20081014%' is the same, right? You should use FieldLikePredicate then or its shortcut, i.e.:

filter.Add(TblAFields.FieldA % "TS-20081014%");

thel
User
Posts: 2
Joined: 14-Oct-2008
# Posted on: 14-Oct-2008 09:26:20   

Hi mihies,

Thanks for the help smile