I'm a beginner so don't quote me. I beleive you need something like: Select hs_identifiers.hs_id_num from hs_identifiers, where (accession_num LIKE (result of another select statement)%);
I beleive that should give you the first part and if there is anything after it. Respectfully, Ligaya Turmelle "Annie Law" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > I would appreciate help with the following. > I have a table where each of the values in a column consists of a > combination of letters and numbers followed by a decimal then a single digit. > Examples of the two types of entries that could be found in this column(accession_num) > are: > BQ877252.1 > AA3588976.2 > and possibly > T84780 > The entries above are found in a table called hs_identifiers. > The hs_identifiers table has two columns accession_num and hs_id_num. > > Given an accession_num I want to be able to look up in the hs_identifiers table to look up for the corresponding hs_id_num. > > This would be a simple select statement for example > Select hs_identifiers.hs_id_num from hs_identifiers, > where (accession_num = (result of another select statement)._) > or (accession_num=(result of another select statement)); > > The only thing is I am not sure what the syntax is for > the part (accession_num = (result of another select statement)._) > > In the section (result of another select statement)._) I am trying to > say the result concatenated with a period concatenated with one wild card character. > For example: result of another select statement = BQ877252 > period is '.' > and wild card character 1,2,3, etc. > The whole string concatenated together would be BQ877252.1 > > thanks, > Annie. > > > > > > --------------------------------- > Post your free ad now! Yahoo! Canada Personals > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]