Here's an example...

SELECT ISNULL(CISCreated, 0) FROM Table will replace all Nulls with zeroes

Sherif - I suggested that you create an UDF or stored procedure to use the t-sql and return the string...is that doable ?!

I'm not sure I understand the question - where do you want to use the field name ?! In your application code ?!

If you do your select * in query...

Have you tried using the IsNull function ?!

Try this:

DECLARE @RoomDescription VarChar(100) (increase len if needed)

SELECT @RoomDescription =

ServiceID, FolderID, 'Accomodation for' + ' ' + RTRIM(Title) + ' ' + RTRIM(PaxFirstName) + ' ' + RTRIM(PaxLastName) +...

Training may be far superior but it has a hefty price attached to it - training in Asian coutries on the other hand is way cheaper & because everybody (&...

Could you post some sample data from your report table ?!

I'm not sure I understand your problem completely - eg: would the start and end dates for period 5 (May)...

when in doubt you can always use ascii values....

you're welcome - thx. for feedback!

If the sample data you posted is as you have it in your table I'm not sure why you need to "group by" at all...

can you not just "select sum(amount)...

Maybe you could create an UDF that returns the string without the commas in the number values - something like this....

DECLARE @position int, @string varchar(35), @newstring varchar(35)

-- Initialize the variables.

SET...

Have you tried explicit conversion to int before storing/retrieving ?!

eg: select cast(left(refno, 2) as integer) ?!

1) Identify all rows where refno NOT LIKE 'A%'

2) Convert remaining rows to int value

3)...

I'm fairly sure you can - I remember an instructor doing something similar for the very same reason (only one server) & giving us a demo...

Could you provide some sample data with expected resultset ?!

I'm amazed at the volume of response this post has generated - Steve - I can't help but wonder if you end each day thinking about the next topic to...