trigger on select

Hi all,

I know that "trigger on select" does not exists, I'm searching something to
accomplish this need:

I have a table, let's say:
[Some_table]
[ID] int primary key
[Flag] bit
[Some_Field] nvarchar(40)

when a user (all user) does a select on a row of that table that has
[Flag]=1 the select statement does not returns the correct value for
[Some_Field] column but a specific value that I specify in the "trigger on
selest".

How can I do this?

"Andrea Caldarone" <> wrote in message
news:...
> Hi all,
>
> I know that "trigger on select" does not exists, I'm searching something
> to accomplish this need:
>
> I have a table, let's say:
> [Some_table]
> [ID] int primary key
> [Flag] bit
> [Some_Field] nvarchar(40)
>
> when a user (all user) does a select on a row of that table that has
> [Flag]=1 the select statement does not returns the correct value for
> [Some_Field] column but a specific value that I specify in the "trigger on
> selest".
>
> How can I do this?

How does your question relate to Windows Servers? Does it perhaps belong
into some database newsgroup?

>
> How does your question relate to Windows Servers? Does it perhaps belong
> into some database newsgroup?
>
>

Sorry I've posted into the wrong ng