Rane wrote: I have a program which generates GUID.Is there a chance that more than one thread spawned at the same time (< 1 millisec) in the same machine to have same GUID?. I don't think so. The GUIDs will be different. “Follow your bliss.” – Joseph Campbell

You have several approaches to this, for example: - use REGEXP_INSTR to find nonnumeric characters. Use this inside DECODE to make the decision if to convert or not - create a small function which returns number. Inside this, use TO_NUMBER and catch the potential error and ignore it. In case of an error, return NULL (or whatever is desired) Mika The need to optimize rises from a bad design. My articles[^]

Funny, I thought we met here. Help me! I'm turning into a grapefruit! Buzzwords!

Hello, yes, I would do the same as you did for converting a string to an integer. By the way, have you looked at this thread[^]? Best regards, Mihai Moga

Rane wrote: I'm trying to register a DLL created by Visual Studio 2005 in Debug Mode.It fails with the return code as 0xc0000005. Are you using regsvr32.exe? "A good athlete is the result of a good and worthy opponent." - David Crow "To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne

This may give a hand of help HookAPI source code[^]

Thanks for your Information! :) Rane

Perhaps you're after a profiler. MSVC 6 comes with one so I assume the newer ones also do. There are also third partly ones like NuMega’s TrueCoverage. Steve

Is it possible to write a universal driver to trap the software interrupts alone. (Any class/API supporting it?) :rose: Rane

#include <sstream> int a,b; // assume initialized from cin std::ostringstream strm; std::string s; strm << "Insert into region(regionID, RegionDescription)Values(" << a << "," << b << ")" << std::ends; s = strm.str(); --Mike-- Ericahist | CP SearchBar v2.0.2 | Homepage | 1ClickPicGrabber New v2.0! | RightClick-Encrypt "That probably would've sounded more commanding if I wasn't wearing my yummy sushi pajamas."   -- Buffy

They were little DOS device drivers used in Win16 coding days to hook the AUX output and write it to the block of memory at 0xB000 that represented a mono monitor. All serious Win16 programming setups had both a VGA monitor and a mono monitor attached, so your debug output and the old CodeView debugger could run on the mono monitor. -- -Blake (com/bcdev/blake)