How do you replace "12" with a variable? Andrew
>-- Original Message -- >From: "David Reid" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Subject: RE: MI-L Where clause >Date: Tue, 9 Sep 2003 00:30:43 -0500 > > >Andrew, > >Depending on the column format of the column for [id] > >Using Query/SQL select from the menu bar, If [id] is a text column: > >Select Columns * >From Table [your table name] >Where Condition id like "12" > >For non-text format (integer, float etc) > >Select Columns * >From Table [your table name] >Where Condition id = 12 > >Hope that helps, >David Reid > > > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Monday, September 08, 2003 11:07 PM >To: [EMAIL PROTECTED] >Subject: MI-L Where clause >Importance: High > > >If I want to select all records where the id equals a set variable how do >I >format the syntax? > >ie > >var_id = 12 >select id from table where id = var_id > > >Regards > >Andrew > >------------------------------------------------ >The information in this e-mail together with any attachments is intended >only for the person or entity to which it is addressed and may contain >confidential and/or privileged material. Any form of review, disclosure, >modification, distribution and/or publication of this e-mail message is >prohibited. If you have received this message in error, you are asked to >inform the sender as quickly as possible and delete this message and any >copies of this message from your computer and/or your computer system >network. > > >--------------------------------------------------------------------- >List hosting provided by Directions Magazine | www.directionsmag.com | To >unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >Message number: 8306 > > Regards Andrew ------------------------------------------------ The information in this e-mail together with any attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any form of review, disclosure, modification, distribution and/or publication of this e-mail message is prohibited. If you have received this message in error, you are asked to inform the sender as quickly as possible and delete this message and any copies of this message from your computer and/or your computer system network. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8307
