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

avatar 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

avatar 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.

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:

x425
x96

asked: Mar 24, 2010 at 12:48 PM

Seen: 1265 times

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

Copyright 2016 Redgate Software. Privacy Policy