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

Searching for names that contain a space

I can't seem to get SQL Search V2 to work where a name has a space in it e.g. [Full Domain]. Any suggestions please? Using AND or % don't work either
Liz.Cooper
0

Comments

9 comments

  • mc1brew
    Hello Liz Cooper,
    Have you tried the "exact match" check box?

    Searching with a space seems to be working for me. However I feel like I've run into this before. I also reinstalled today and I am using version 2.0.1.30. Not sure if maybe they've recently made any changes.

    Let me know if you find the solution to your problem.
    mc1brew
    0
  • RickyR
    Hi Liz,

    Thanks for your forum post!
    Let's take this case off the forums and work on this offline, as it seems that we will need to do some investigation as to why this is occurring. I will be replying to you through the portal system.

    Thanks!

    Rick
    RickyR
    0
  • Liz.Cooper
    Exact match does work, thank you
    Liz.Cooper
    0
  • cnovac
    Hi,
    Is there a resolution for this? I'd like to search for insert into x, but exact match doesn't work and if you don't use exact match, it give hits for partial matches on insert/into/x. Thanks.
    cnovac
    0
  • Liz.Cooper
    This does work for me. However maybe you have a tab instead of a space? I am on V2.0.1.36
    Liz.Cooper
    0
  • cnovac
    Hi, Thanks for reply. Seems to be issue with tables that have _ in the name. In my example: insert into license_attribute

    As soon as you type in the underscore, the search with exact match stops working.
    cnovac
    0
  • Liz.Cooper
    Sounds like a bug there.
    We have hardly any tables with underscores in their name so I can't check this for you, I'm afraid.
    Liz.Cooper
    0
  • cnovac
    Hi, how can I file this with support at Redgate? Thanks.
    cnovac
    0
  • Liz.Cooper
    Liz.Cooper
    0

Add comment

Please sign in to leave a comment.