Mosio - Mosio Mobile Search // cadill: If I have a table column in the database that contains the single character 'Y' or 'N', how can I make a select query format on that column print the full word "Yes" or "No" in its output instead of just the single character?

Mosio - questions. answers. people.

Questionarium

Apps

FYI

cadill on Mosio

cadill

Boston guy

Name: Cadill
Location: Boston
Web: twitter.com/cadill

11 Qs, 9 As, 0 FYIs

Join
or
Log In

1 in cadill's Qniverse:

Fixitfox

Buy a Mosio T-Shirt!

cadill's Questions | Answers | Friends | FYIs

Home | Questionarium | Apps | FYI | Search

Question

If I have a table column in the database that contains the single character 'Y' or 'N', how can I make a select query format on that column print the full word "Yes" or "No" in its output instead of just the single character? Join or Log In to answer.

-cadill (11Q / 9A)
Sat Jan 12, 2008 8:08am

You talking Excel or Access?

-bigmike (33Q / 2522A) Sat Jan 12, 2008 10:06am

SQL Plus

-cadill (11Q / 9A) Sat Jan 12, 2008 1:05pm

Comments:

I'm doing a SELECT command in SQL Plus. Need the select command to print "Yes" for Y and "No" for N

-cadill (11Q / 9A) Sat Jan 12, 2008 2:25pm

You figure it out? I don't know SQL at all (because i don't have to and that's what IT departments are for)

-bigmike (33Q / 2522A) Sat Jan 12, 2008 11:43pm

Comments:

I didn't figure it out :(

-cadill (11Q / 9A) Wed Jan 16, 2008 6:40am

(To cadill)
Asktheadmin.com might be helpful... or SQL for Dummies or something like that

-bigmike (33Q / 2522A) Wed Jan 16, 2008 6:57am

select replace(replace(Answer,'Y','Yes'),'N','No') from Table;

-cadill (11Q / 9A) Mon Jan 21, 2008 3:20pm

Permalink

Join or Log In to answer.