Searching for names that contain a space

Liz.Cooper

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

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.

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

Liz.Cooper

Exact match does work, thank you

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.

Liz.Cooper

This does work for me. However maybe you have a tab instead of a space? I am on V2.0.1.36

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.

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.

cnovac

Hi, how can I file this with support at Redgate? Thanks.

Liz.Cooper

Try: https://redgatesupport.zendesk.com/home