How to Pad Values in Microsoft Access

Поділитися
Вставка
  • Опубліковано 11 гру 2024

КОМЕНТАРІ • 7

  • @SAMYTAHER
    @SAMYTAHER 5 місяців тому +1

    Great, thank you very much, keep it up

  • @simonmaersk
    @simonmaersk 5 місяців тому +1

    Hi Sean. Great tip! For left padding, I simply use the Format function. So "Format("123", "00000")" returns "00123". However, I have never needed right padding, so the method you showed will definitely come in handy if I ever need it.

    • @seanmackenziedataengineering
      @seanmackenziedataengineering  5 місяців тому

      Great tip! That's a good one. I think lots of people also just concatenate the string "00000" or "XXXXX" or whatever, then get Right/Left.

  • @tuffley2175
    @tuffley2175 5 місяців тому +1

    📝
    Is it possible to pad with random numbers and unique!!!!
    ( when I ask for a rise I get left padding increase😢)

    • @seanmackenziedataengineering
      @seanmackenziedataengineering  5 місяців тому

      I see! That's a great idea - nice idea to use random numbers but that would be another video (cool one). We would look into a random function for that 🛠

    • @tuffley2175
      @tuffley2175 5 місяців тому

      Good on you
      (Attitude of a MVP)🎬