Paul,

You may get more luck if you try and break down your problem.. that's an awful lot of code for someone to try and work out what's going on!

Alex

Fred,

im such a dumbass... of course it's ordering- it's ordering alphabetically! i thought for soem reason it would order still based on JFMAMJASOND order...

der..!

mike thanks for the reply,

cheers- i need to be able to distinguish which results belong to which field id though.. with thati cant be  sure, no?

alex

mike, sorry i cut out the bottom bit to save space

basically i want to join onto a table using an event id (26). this event id, along with the fieldid...

Have found a work around.. no worries!

Guess you've tried the replace function..

eg REPLACE(table.field, CHAR(32), '')

where CHAR(32) is a space...

brilliant, thanks again chris!

Thanks Chris... just one more thing (like Columbo)

if i use

SELECT CASE WHEN x LIKE 'A%' THEN 'blah'

How do i add WHEN y LIKE 'B%' THEN 'blah2'?

cheers!

may have to be the only way Chris... great.

cheers for the above, didnt know that.

Can you alias the results so..

select case 1 when in (1, 2) then 'a' else 'b'...

You should see this piece of p00 report writing tool that im lumbered with. seriously.

cheers sushila for the suggestion althuogh it's not quite what im after.

as an aside.. can you...

No, it's for a RTF file?

Berilliant guys, suggestions worked a treat!

Sorry.. just noticed the folllwing:

SELECT ISNULL (EntityPhoneNumbers.PhoneNumber, 'None')

FROM Entity

LEFT JOIN EntityPhoneNumbers ON Entity.EntityID = EntityPhoneNumbers.EntityID

WHERE Entity.EntityID = ||EntID|| (this is a value passed to it)

works fine n dandy but...

Cheers Chirs, Govind and Noel. Ive been having to write SQL in this really cr4ppy basic report writing tool that doesn't allow any procedural stuff.

Noel's suggestion worked a treat mind,...

Hi Greg,

Thanks for posting. I've spent pretty much all day trying to figure it out and i have now (time difference n all that). Basically on the job history it...