We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Compare Two Columns From the Same Dataset where Column X = INSTR(Column Y, 0, 1)

Comments

2 comments

  • Avatar
    Infogix Support
    Originally posted by: stonysmith

    Originally posted by: sheryle_paisley
    					

    Does anyone know how to convert this sql to BrainScript?

    case when COLUMN X = INSTR(COLUMN Y, 0, 1) then 'Y' else 'N'
    The syntax of your request looks off.

    To search for X in Y:
    if findStr(Y,X) >-1 then 'Y' else 'N'

    To compare a substring:
    if X = substr(Y,0,1) then 'Y' else 'N'
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: sheryle_paisley

    Oh, Thank you... I missed some of the code...
    I'll give it a try.
    0
    Comment actions Permalink

Please sign in to leave a comment.