How can we help you today? How can we help you today?

Typing single quote in WHERE clause

I have a problem when I type a single quote after LIKE in a WHERE clause that the quote is moved before the LIKE instead of after where I type it.

Examples:
When I type: WHERE fieldname LIKE '
It becomes: WHERE fieldname 'LIKE

This is pretty annoying as I use LIKE a lot.

Same happens for other commands in the WHERE clause:
When I type: WHERE fieldname CONTAINS '
It becomes: WHERE fieldname ÇONTAINS

When I type: WHERE fieldname BETWEEN '
It becomes: WHERE fieldname 'BETWEEN

Niels
dh3201
0

Comments

5 comments

Sort by
  • Tilman
    Hi Niels,

    thanks for posting. I'm afraid I wasn't able to reproduce your problem. Could you tell me a bit more about your system and what editor you are using?

    Thanks,

    Tilman
    Tilman
    0
  • dh3201
    I'm using the query editor in Microsoft SQL Server Management Studio 2005 on Microsoft Windows XP Professional Version 2002 Service Pack 2.

    The same thing happen with the double quote (").
    When I exit SQL Prompt it does not happen.

    Niels
    dh3201
    0
  • Tilman
    Hi Niels,

    I'm afraid I still can't reproduce your problem. Could it be that you are using a non-English system (OS, keyboard layout etc.)?

    Regards,

    Tilman
    Tilman
    0
  • dh3201
    I think it was language related.
    I just got a new PC with most of the software (including WinXP) installed in English, while it was Dutch on my old PC.
    Now this doesn't happen anymore.
    dh3201
    0
  • Tilman
    Cool. We are aware of language issues with SQL Prompt 2, which basically means it doesn't work on non-English systems. We are planning to have SQL Prompt 3 working properly in (almost) all cultures.

    Regards,

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.