tale103108
New Member
I have used many databases and can do
SELECT COUNT(DISTINCT col)) as colname
FROM mytable;
but having problems with Progress.
Question: How do you count distinct rows?
Also, what is the equivalent to the Oracle REPLACE command? (which search a string and replaces all occurances of a char with another char)
Example: (Oracle SQL)
SELECT REPLACE(name,'L','O') as new_name
FROM employee;
now all 'L' are replaced with 'O'
Cheers.
SELECT COUNT(DISTINCT col)) as colname
FROM mytable;
but having problems with Progress.
Question: How do you count distinct rows?
Also, what is the equivalent to the Oracle REPLACE command? (which search a string and replaces all occurances of a char with another char)
Example: (Oracle SQL)
SELECT REPLACE(name,'L','O') as new_name
FROM employee;
now all 'L' are replaced with 'O'
Cheers.