Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Create SQL FullText statement via VB.Net RE: Create SQL FullText statement via VB.Net

  • January 24, 2017 at 2:44 am

    #1924545

    John Mitchell-245523 - Tuesday, January 24, 2017 2:37 AM

    Is it as simple as just removing the ControlChars from your VB code?
    Dim fltrStr As String = "Contains(dbcode, '" & "*3*" & "')"

    John

    Thanks, John Mitchell for fast response. I did try as your suggestion but it turns out  
    Contains(dbcode, '*3*')  and no result return from the query.
    I want it the filter to be Contains(dbcode, '"*3*"')

    Together, we can make wonders!