Posted by Erland Sommarskog on 09/11/07 21:36

amj1020 (angelicred19@hotmail.com) writes:
> Need help with a query.
> I need to get a date from table1 where the symbol is equal to OQY7 but
> the symbol in table table2 is OQY07.
> How do I get it to look for the first three characters plus the fifth
> character by skipping the fourth character?

Use the substring() function. Or left() and right(). All of them are
described in Books Online. I recommend you to look at all string functions,
because you don't know which one you may need next.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: One bound form does NOT save record - please help!
• Prev in forum: Re: How would you... (binary info in a table)
• Thread view: Re: Query Help using SQL Server

[Reply to this message]