x

What is the full name and telephone number of all consultants who live in Orlando

CONSULTANT C_ID C_LAST C_FIRST C_MI C_ADD C_CITY C_STATE C_ZIP C_PHONE C_EMAIL 100 Myers Mark F 10 Sky Blvd. Orlando FL 32825 4075551212 mm@xx.com 101 Hernandez Sheila R 33 Left Cr. Orlando FL 32811 4071115555 sh@yyx.com 102 ZHANG Brian 89 SE Ave. Tampa FL 32822 3211515555 bz@mm.org 103 Carlson Sarah J 22 NW Pl. Orlando FL 32825 4075111111 sc@uu.gov 104 Courtland Paul R 91 Water St. Orlando FL 32800 4075151155 pc@pp.net 105 Park Janet S 15 High Rd. Miami FL 32816 9541115555 jp@hr.net 
more ▼

asked Mar 24, 2010 at 12:48 PM in Default

Michael 4 gravatar image

Michael 4
9 9 9 9

Michael, what are you trying to ask? I would recommend that you put the question in with your sample data and explain your problems clearly.
Mar 24, 2010 at 12:50 PM Fatherjack ♦♦
Mar 24, 2010 at 06:02 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Again, question not well laid out - please fix in future requests. Also, a visit here wouldn't go amis.

select  c.c_first + ' ' + c.c_mi + ' ' + c.c_last as name,  c.c_phone from consultant c where c.c_city = 'orlando' 
more ▼

answered Mar 24, 2010 at 02:31 PM

user-1392 gravatar image

user-1392
71 1

+1, but please can you use the code format button? thanks
Mar 24, 2010 at 06:02 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x369
x74

asked: Mar 24, 2010 at 12:48 PM

Seen: 1074 times

Last Updated: Mar 24, 2010 at 06:01 PM