"Hallgeir" <halldetteskalvekkgeir@start.no> wrote in message
news:pOyTb.32072$BD3.7209500@juliett.dax.net...
> I have a SQLServer2000 database in which I have created a view. I want
> to convert numeric values in a colum to string values, straight forward.
> Example: the number 25 I want to convert to the string 25, number 7 I want
> to convert to the string 7 and so on, and most import I want to convert 0
to
> an empty space. I hope you be people are able to understand what I mean. I
> guess my english could be better.

> > I have a SQLServer2000 database in which I have created a view. I want
> > to convert numeric values in a colum to string values, straight forward.
> > Example: the number 25 I want to convert to the string 25, number 7 I
want
> > to convert to the string 7 and so on, and most import I want to convert
0
> to
> > an empty space. I hope you be people are able to understand what I mean.
I
> > guess my english could be better.
>
>
> If the column is column_name then you should
> check the CAST statement in the online doco.
> try:
>
> cast(column_name as varchar)
>
> Cannot immediately recall how zero's are handled
> but if you have problems then include a case
> statement to the effect:
>
> case when column_name = 0 then ' ' else cast(column_name as varchar) end
>
>