none
Query SQL - Show Only Numbers RRS feed

  • Question

  • i want show that user ip without "'b" that ip show like this: 192.168.43.228

    someone can know if Query to casting or convert fo this?


    Saturday, October 17, 2020 10:21 PM

All replies

  • i want show that user ip without "'b" that ip show like this: 192.168.43.228


    Hi,

    I could not understand the requirement exactly

    Could you please share an input text and desired output from that?

    Do you want to remove dots "."

    declare @ip varchar(100) = '192.168.43.228'

    select replace(@ip,'.','')



    SQL Server Tutorials


    • Edited by eralper Sunday, October 18, 2020 5:34 PM
    Sunday, October 18, 2020 5:32 PM