asked on

Query syntax for inserting a tab between results/columns

Greetings,

My query:

SELECT (Entity + ' ' + Name) FROM Entity Order By Entity

Is there anyway to insert a tab instead of a space. I'm using the results in a C# combo box. I want the two columns placed in one row of the dropdown box. A space really isn't enough for ease on the eyes.

Thanks

ASKER CERTIFIED SOLUTION

dsacker

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

SOLUTION

Meir Rivkin

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

dsacker

My bad. Meant CHAR(9).

SOLUTION

Kyle Abrahams, PMP

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

SOLUTION

Jim Horn

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

John500

ASKER

Thanks to all !

When I tried:

SELECT (Entity + CHAR(9) + Name) test FROM Entity Order By Entity

The result comes out correct in the C# combo box but only for any item selected or indexed. Otherwise, when the dropdown arrow is clicked all the other results show side-by-side with no space whatsoever. You would think once the box got filled it would fill correctly, no?

As I say, any item selected will display correctly. I need to look closer at ged3 suggestion...

John500

ASKER

Still couldn't get the end result to appear correctly in the drop-down...