Mark, this is an old one:

Just take out spaces around '>' characters that you don't want
interpreted as pipes.

"Remeta, Mark" wrote:
>
> Hello all, how do you do a sql query from the command prompt using a > in
> the where clause?
> everytime I try adsm tries redirecting the output to whatever is to the
> right of the >.
> sorry if this is a stupid question...
>
> Thanks,
>
> Mark Remeta
> Seligman Data Corporation
> 100 Park Avenue
> New York, NY 10017
>
> Confidentiality Note: The information transmitted is intended only for the
> person or entity to whom or which it is addressed and may contain
> confidential and/or privileged material. Any review, retransmission,
> dissemination or other use of this information by persons or entities other
> than the intended recipient is prohibited. If you receive this in error,
> please delete this material immediately.