Get Numbers From String SQL easiest method

[@hasanmougharbel8030]

I am a new sql learner, and feeling joyous to learn from this channel. I have only simple enquiry. I came across the varchar() function... What is the best practice when deciding to chose a number for that function given i am going to extract names for example...Can i put 1000 for instance so that i can be in the safe side or that may rise problems. Thanks a lot.

[@beshoysadek643]

Hi, I recommend using NVARCHAR which should be compatible with all types of languages. you can use 1000. All that’s going to do is just allocate more memory during the execution but you really shouldn’t be dealing with names longer than 50-100 for almost all cases

[@hasanmougharbel8030]

@@beshoysadek643 great advice..thanks a lot