I downloaded and configured eclipse cdt along with MinGW and able to compile c programs.

My question, how to start executing the program in command prompt when Run option clicked from eclipse. Currently it always executes the program in eclipse console.

Reason to have command prompt for executing c programs is to accept user inputs.
I would also like to know is there a way to accept user inputs when c program running in eclipse console.

Thanks in advance,
-Manju
['https://Stackoverflow.com/questions/12726149', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/612465/']
Yes. 

```
 select 
    substring(data, 1, PATINDEX('%[0-9]%',data)-1) as ename,
    substring(data, PATINDEX('%[0-9]%',data), len(data)) as sal
 from 
     table

```
```
SELECT SUBSTRING(@ourName, 1, CHARINDEX(' ', @ourName)) AS [First],
SUBSTRING(@ourName, CHARINDEX(' ', @ourName) + 2, LEN(@ourName)) AS[Last]

```