Search results for query: *

Mintjulep - it has no relevance to the issue, it is not a formula just done on judgement. Skip - I got lost at the very end. When you sort do you +1 to every row? How does this sort the sequence out? Thanks

Things such as financial impact, business benefits etc ..

Hi, I'm hoping someone can help with an issue I have with a spreadsheet I manage at work. I have a large excel sheet of change requests. Anything not currently planned in a release has a priority assigned to it, 1, 2, 3 .... etc Note that the rows are not next to one another as its a large...

Yes thats it PHV! Great stuff, many thanks to both. I thought the escape character was backslash, must be single quote then.

Thanks Ken, the problem is I cant work out how to put the single quote in the sql command? I have tried escaping the character like rtrim(n.surname)||',\''||rtrim(CD.DAY_PHONE)|| I have also tried rtrim(n.surname)||','||'\''||rtrim(CD.DAY_PHONE)|| When ran gives the message "ERROR...

Hi All, I have a script that is using sqlplus to pull information from a database. I need this in a excel report to then email to the business. I have done it to create a csv file, looks fine but when I then open the file with excel the phone numbers have any leading zeros removed. How can I...