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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dsquare

    SUBSTR and the LIKE Predicate

    It appears as if this works. Thanks, DSquare
  2. dsquare

    SUBSTR and the LIKE Predicate

    Does Teradata allow the use of functions within the LIKE predicate evaluation? For example, can the following code be done in Teradata. Where t1.f1 LIKE '%SUBSTR(t2.f2,1,3)%' Thanks DSquare
  3. dsquare

    Trimming multiple values from a field?

    BillDHS, This would work if a space is always after the street number. However, there are international addresses that use various characters immediately after the street number (EG. 123,main). Thus, the potential is that any non-numeric character could follow the street number. I am...
  4. dsquare

    Trimming multiple values from a field?

    I have searched through the FAQ and did not find an answer to my question/problem. I'm am working on DBC Release V2R.04.01.01.01, DBS Version 04.01.01.06. I am trying to strip out the leading numbers that are found in and address field. For example, 123 MAIN ST translates to MAIN ST. The...

Part and Inventory Search

Back
Top