Changing a Column datatype

Hello I am having a table
table1
col1 (bit)
and i want to changethe col1 type for smallint
col1 (smallint)
true will be = 1
and false = 0
how can i do it ??
thank youJust change it using Enterprise Manager. The existing values will be implicitly converted.|||i must change it from a script
but i found it

thank you|||Change it in Enterprise Manager, and then click the icon that scripts your change.

Change property based on actual state of collapsed/expanded group

Hi, please I would like to use something like this>

=IIF(table1_group2 is Collapsed,True,False)

I want to generated some event based on actual state of e.g. report group. if user expand group make this event otherwise (group is collapsed) make another event.

Thanks for your advice.

Any Answers? Please send me the link where it was disccussed or it's impossible to do it?|||I'm also looking for a similar solution. Any luck?

change parameter prompt for boolean

How can I have a boolean parameter show yes and no instead of true or false?
TIA
deanOn Aug 24, 11:43 am, "Dean" <deanl...@.hotmail.com.nospam> wrote:
> How can I have a boolean parameter show yes and no instead of true or false?
> TIA
> dean
You should create a parameter and give it string values of 'yes' and
'no.' As far as I know, changing the boolean values directly is not
possible. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant