hi, I'm sorry but Parameters option dosn't exist. I'm using Sql Server 7(Enterprise Manager). Perhaps that option belongs to another version, but I don't have another available one.

thanks a lot.

hi dude, thanks 4 your answer.

but i need to do something like this:

select * from table where fieldvalue= <dtsglobalvar1>

u got it?

i need to use an external parameter to find data...

this option isn't available on mi version.

so i'm looking 4 another solution.

thanks

sl3

thanks, but i need to use the parameters on a sql script.

For Example: select * from table where fieldvalue = dtsglobalvar

do u understand?

thanks.

sl3

thanks 4 your answer, but i still having the problem 'cause i have sql server 7 and aparently the Dynamic doesn't exist in this version.

have u another solution about this...

no, actually i wanna use a globalvar in a sql script.

Thanks anyway.

sl3