how can we use 'or'in query

Question

Post reply

how can we use 'or'in query

jagpalsingh4

Ten Centuries

Points: 1311
More actions
March 18, 2008 at 6:25 am

#183361

hi,
plz check this query and find out y its not running .where is the fault
select 'my details'=addressline1 +or+'city' from person.address
thaxxx
regards
jagpal singh

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Piotr.Rodak SSCrazy Eights Points: 9376 More actions · Answer 1

What is you want to achieve?

Piotr

...and your only reply is slàinte mhath

jagpalsingh4 Ten Centuries Points: 1311 More actions · Answer 2

hi,

i just want to run this query i think i am doing some mistake with syntax.so plz check it

Gonzalo-603688 Old Hand Points: 384 More actions · Answer 3

jagpalsingh4 (3/18/2008)
hi,
plz check this query and find out y its not running .where is the fault
select 'my details'=addressline1 +or+'city' from person.address
thaxxx
regards
jagpal singh

Hi,

I don't understand what you want...

However, I would recommend you to check the CASE clause.

Cheers,

Gonzalo

Adam Haines SSC-Insane Points: 23217 More actions · Answer 4

hi,
plz check this query and find out y its not running .where is the fault
select 'my details'=addressline1 +or+'city' from person.address

This entire statement is wrong.

I believe you want something like this, but this is a guess.

SELECT AddressLine1 AS [My Details],

City

FROM Person.Address

My blog: http://jahaines.blogspot.com

jagpalsingh4 Ten Centuries Points: 1311 More actions · Answer 5

hi

thaxxxxxxxxxxxxxxxxxxxxxxxx

i need this

regards

jagpal singh