Trimming a COUNT column 1

[DayLaborer]

This line (obviously) works:

select (count (*)) from crdcrm.employee where firstname = 'John'

but this one does not:

select [b]ltrim[/b](count (*)) from crdcrm.employee where firstname = 'John'

I get the error message:

SQL0171N The data type, length or value of argument "1" of routine "LTRIM" is incorrect. SQLSTATE=42815

What can I do to trim the column that reports the count?

Thanks,
Eliezer

 

[fredericofonseca]

select ltrim(cast(count (*) as char(20)) from crdcrm.employee where firstname = 'John'

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[DayLaborer]

Frederico,

Thanks for replying. When I tried exactly what you posted, I get this:

SQL0199N The use of the reserved word "FROM" following "" is not valid. Expected tokens may include: "+ - AS ORDER".

Eliezer

 

[SkipVought]

Try adding the missing RIGHT PARENTHESIS

select ltrim(cast(count (*) as char(20))[red][b])[/b][/red] from crdcrm.employee where firstname = 'John'

Skip,

_{Did you hear what happened when the OO programmer lost his library?...
He's now living in OBJECT poverty!}

 

[DayLaborer]

Heh, heh, heh...

Thanks very much!!!
Eliezer

 

[fredericofonseca]

OOPS.

Thanks for the star

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Mercury2]

select char(count(*)) from ...
seems simpler to write.

 

[DayLaborer]

Mercury, how many CHARs does that allot? i.e. does it trim? If so, what/how?

Thanks,
Eliezer

 

[BrianTyler]

Eliezer,

If you still want it to be left justified (ie you are trying to get rid of some of the leading zeros, you could use:

select substr(digits(count(*)),6,5) from crdcrm.employee where firstname = 'John'

Brian

 

[BrianTyler]

Sory - my age is showing. It should be 'right justified' in the previous post

Brian :<(