Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by 123blyzzard

  1. 123blyzzard

    How to trim the characters from a string?

    Thanks..It worked
  2. 123blyzzard

    How to trim the characters from a string?

    Thank you all, I really appreciate your help. I created an update query and used the left and len function to get rid of space and Color string. But to make this query more generalized in case if there are different strings after space like "Red Signal" or "Red Color" in the same column on...
  3. 123blyzzard

    How to trim the characters from a string?

    Do i need to use subquery to create a new column?
  4. 123blyzzard

    How to trim the characters from a string?

    HI, I have a field named Colors in a table A and The same field Colors in Table B. But in table A, I have "Red Color", "Blue Color" and "Green Color" and in table B only "Red", "Green" and "Blue". Now I need to connect table A to Table B on Colors and thus need to remove " Color" from table A...
See more

Part and Inventory Search

Back
Top