Professional Web Applications Themes

Using functions in Query yzer - escape character? - Microsoft SQL / MS SQL Server

How do I use a function in query yzer in a 'where' string clause? Is there an escape character? EG: If I wanted to do something like...WHERE FieldName LIKE '% Left(SomeField, 1) %' Thanks, Chris...

  1. #1

    Default Using functions in Query yzer - escape character?

    How do I use a function in query yzer in a 'where' string clause? Is
    there an escape character?

    EG: If I wanted to do something like...WHERE FieldName LIKE '%
    Left(SomeField, 1) %'

    Thanks,

    Chris


    Chris Guest

  2. #2

    Default Re: Using functions in Query yzer - escape character?

    Hi

    Try

    WHERE FieldName LIKE '%' + Left(SomeField, 1) + '%'

    John

    "Chris Ashley" <co.uk> wrote in message
    news:bf37gt$aa92f$news.uni-berlin.de... 


    John Guest

  3. #3

    Default Re: Using functions in Query yzer - escape character?

    "John Bell" <com> wrote in message
    news:3f1526a5$0$3135$news.pipex.net... 

    Hi John,

    Thanks for that. :)

    Chris


    Chris Guest

Similar Threads

  1. Replies: 0
    Last Post: October 9th, 06:09 PM
  2. Escape character in SQL - how do I ignore ?
    By caledoniaman in forum Coldfusion Database Access
    Replies: 2
    Last Post: September 30th, 12:20 AM
  3. Escape character when setting variable
    By Joe S. in forum Macromedia ColdFusion
    Replies: 0
    Last Post: February 23rd, 12:30 AM
  4. explode and escape character for string separator
    By Chris Shiflett in forum PHP Development
    Replies: 7
    Last Post: July 18th, 08:09 PM
  5. Replies: 1
    Last Post: July 2nd, 09:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139