PPRuNe Forums - Search Results

Search: Posts Made By: henrybluebottle

Showing results 1 to 7 of 7
Search took 0.00 seconds.

Forum: Australia, New Zealand & the Pacific

11th Sep 2016, 09:30

Replies: 1

One dead in light aircraft crash at Parafield

Views: 3,818

Posted By henrybluebottle

One dead in light aircraft crash at Parafield

Planes collide at Parafield Airport north of Adelaide, one believed dead - ABC News (Australian Broadcasting Corporation)...

Forum: Computer/Internet Issues & Troubleshooting

19th Jan 2012, 00:03

Replies: 5

SQL and embedded carriage returns

Views: 1,103

Posted By henrybluebottle

Mixture, The 4th option (like...

Mixture,
The 4th option (like '%'||chr(13)||'%') worked perfectly.
Thanks again.

Forum: Computer/Internet Issues & Troubleshooting

15th Jan 2012, 09:01

Replies: 5

SQL and embedded carriage returns

Views: 1,103

Posted By henrybluebottle

Thanks. It would be an ongoing query but only...

Thanks.
It would be an ongoing query but only once every couple of months. Not a large file so timing isn't an issue, and it's a vendor's database so couldn't play with indices etc. I'll try your...

Forum: Computer/Internet Issues & Troubleshooting

15th Jan 2012, 08:16

Replies: 5

SQL and embedded carriage returns

Views: 1,103

Posted By henrybluebottle

Thanks, mixture. So could I say "select * from...

Thanks, mixture.
So could I say "select * from myfile where mycol like '%chr(13)%' " given that I don't know where the CRs are, or what would the best syntax be ?

Forum: Computer/Internet Issues & Troubleshooting

13th Jan 2012, 09:37

Replies: 5

SQL and embedded carriage returns

Views: 1,103

Posted By henrybluebottle

SQL and embedded carriage returns

I wonder if anyone knows how to search a column in SQL for embedded carriage returns ? I assume it would be a "like '%...%' " but do I use a chr(13) or /n or what ? It's Oracle BTW.

thanks,
HB.

Forum: Passengers & SLF (Self Loading Freight)

16th Feb 2011, 09:27

Replies: 40

Trousers Off Please

Views: 7,132

Posted By henrybluebottle

Supposing you had been going commando ...:uhoh:

Supposing you had been going commando ...:uhoh:

Forum: Australia, New Zealand & the Pacific

11th Oct 2010, 22:44

Replies: 3

Car rammed into Adelaide Airport

Views: 1,319

Posted By henrybluebottle

Car rammed into Adelaide Airport

"A MAN has driven a car into safety barriers at Adelaide Airport and run on to the tarmac in a major security incident.
The driver, believed to be aged in his 30s, has been arrested by Australian...

Showing results 1 to 7 of 7