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 dencom 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: *

  • Users: gabydrdoom
  • Content: Threads
  • Order by date
  1. gabydrdoom

    Concatenate 2 fields in 1 field with condition

    Helo, I have a table with two fields named map1 and map2 and I want to make concatenation according to the following model: map1 map2 map12 100001 1 100001001 100001 22 100001022 100001 87 100001087 100002 999 10000299 I want to concatenate like this...
  2. gabydrdoom

    Replace a number

    Hello How do I replace a number with a string that has the last number identical to the number Example: Excel1 NR 1 1 1 2 2 2 3 3 3 Excel2 INT int_RR_001 int_RR_002 int_RR_003 int_RR_004 int_RR_005 Thanks
  3. gabydrdoom

    35 tables with the same structure in one

    Hello! I have 35 tables named id_01, id_02, ... id_35 with the same structure. How can I make a single id_total table?
  4. gabydrdoom

    replace all values in a column with length equal to X

    Hi! How do I replace all values in a column with length equal to 10? Ex: 2535848577 5487 535 66666 5366666655 758675 replacement only values with length equal to 10 Merci!
  5. gabydrdoom

    replace null values with the last value other than null

    Hello! how do I replace null values in a column with the last non-null value? Ex: Column Column AB AB null AB CT CT null CT null CT BH BH null BH null BH SV SV TM TM Thank you!

Part and Inventory Search

Back
Top