Hi guys, I have a table with customer information. Some entries are invalid. Way to find them out is by invalid customer name like ‘dguychjki’.. no definite rule. More so like you get to know that it does seem right. How best to extract such entries for further review? What condition do I put in where clause of sql?

like
Posting as :
works at
You are currently posting as works at

https://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/

Extract the known good ones and filter those out?

If you don’t have a list of “valid” names, then don’t.

Related Posts

My kind of protester.

Post Photo
likefunnysmart

🐠 Would you rather work on award winning next level creative with zero work life balance or churn out mediocre work and have a healthy work life balance?

like

My challenge to everyone of you. Every leader, every future leader, everybody who will lead this industry one day: when we get back to normal, whatever that will look like, get personally involved again with recruiting, hiring and mentoring. DO NOT leave personnel decisions to HR, alone. DO Not rely on the parasitic temp agencies like creative circle and Aquent to do all the work. Get involved. Give a damn. A creative leader saw value in me, l assume someone saw value in you too. Pay it forward.

likeupliftingsmartfunny

When an agency is about to hire you as a creative lead but without seeing your book to find out what you had done in your career, is that a red flag to you as a creative?

like

I’m beginning to think all the 2020 SB briefs started with... “we need a big personality to represent our brand.” Since when is celebrity a substitute for concept?🤔

likesmart

Hi friends, I’ll kickstart the bowl! Share what your small business is and drop a link!

like

How common are prenups in UK among middle-class? I'm thinking of asking my SO for one but I worry it would be viewed by anyone else as a one foot-out-the-door kinda situation. I'm just trying to be safe with little I have, seeing my friends' marriages.

Guys..how is nps thing works at Bosch..in offer letter it was given as 50k as nps and that also excluding the CTC..any hint will help

like

Anybody want Sly? He's moving out tmr. He's one of my starter and really grew on me. Sad to see him leave but want a good home for him!

Post Photo
like

I’m in SF but nervous to officially come out to my friends even though I’m sure they all know/assume anyway. :(

like

Breakup etiquette- we broke up and I was supposed to go to his relatives’s wedding in a couple of weeks. I know the couple, not super well, but have hung out and texted individually as well. Should I let them know I won’t be attending and wish them well or don’t reach out to them?

like

Huge alimony reform bill - am I alone in having a gut feeling that the new alimony bill will cause more litigation, not less? Looking for experienced lawyer's opinion, maybe who's practiced through such a similarly huge change in a law?

like

Been with my GF since college and we recently hit the 4 year mark. 1-2 years into our relationship I found out she had instances of micro-cheating (flirting with guys, talking to ex’s etc - but nothing physical) and we addressed it. To her credit and my knowledge, she’s been apologetic and great at respecting boundaries since, but I still feel the pain from her actions years ago (and have talked to her about it). Feeling lost about whether to just leave or to try and work things out

like

Hi i am 28m, staying in a PG at gachibowli, any females for a casual meet and talk on weekends, plz respond

like

Love that in true form I chose the 1 red meme stock. 😂💎💎💎

like

Anyone else hammering AEO puts?

likefunny

What’s the highest total compensation you’ve seen or heard of for a UX Designer?

I’m specifically asking about recurring employee pay, and not onetime stock sales from exit events at startups.

like

Hi Fishes,

I am trying to explore and obtain a career opportunity in UK or Europe. Could you all help me with how to go about it or any suggestion how to get an interview and move to UK for work.

like

How does your workplace measure the success of a marketing campaign and do you think that method is a valid/smart way of measuring it?

likeuplifting

Curious to hear thoughts on how the recent rally is being perceived. Is it another of those temporary moves? Or does it reflect a view that the market bottom is behind us now?

like

Additional Posts in Technology/IT Consultants

I’m at a point in my life that just want to quit and become a school counselor 🙄. I need to feel what I do can make a difference in something. Anyone has experience with such harsh transition? I always wanted to be come a psychologist

like

Do you get the feeling that there is a higher image promotion of women/minority people in Tech?I have seen way to many pictures from major tech companies that promote far more women/minorities than white males in their marketing materials.Wouldn't be better if we hired the best people no matter what the race/gender is?I know some companies are not publishing any gender/race stats but you cant't really demand a 50/50 ratio.Also there is no coincidence that most execs is some companies are British. So this goes both ways.

likesmart

I had 4 rounds of interviews with Microsoft recently. How many days will Microsoft take to share the result. Any idea?

like

That moment when you realize you did not press Ctrl-s and kept working on your excel sheet for hours 💻 📊

And then.. *drumroll*

it effing CRASHES...!!! #FMFL

🤦🏻‍♂️😖😣😡😤😩😫

like

Lots of companies who have that ONE guy who manages the legacy system are sh!ting their pants that the 'hit by a bus' scenerio is about to go down.

funnylike

Do any of you use Jo Malone ?

Anyone familiar with Amazon's Solution Architecture team. Sounds like pre-sales /architecture type work. inputs on work, culture, pay, etc. appreciated

What is the comp ceiling long term look like for staying in cloud consulting technical career compare to moving into SWE?

like

Does anyone work for Capgemini invent? Got a call from a recruiter but looking for more details

like

Received a 105k base salary offer for a Data Analytics Consultant position. I had 3 years of industry exp before joining - Do you guys feel that was a decent offer?

like

Does anyone know how to become an independent contractor?

like

Looking for 2 to 8 YOE for lateral hire in Technology consulting roles. Folks with red hat, open shift, RPA, BPM, Salesforce CRM, big data & Analytics experience and certification, DM me for referrals.

like

SAFe SPC certified. 5 years of agile project, program management and release train engineer experience. Anyone looking to hire? Not a fan of PwC. Leaders in my area are frustratingly uninspiring.

funny

What’s the most effective way to train 200+ Staff on new technology or system releases? What do big companies do?

My thoughts are to build a community where Staff can talk and answer each other’s questions through MS Teams, but can that really be done effectively?

like

What is the official vacation announcement for EY during 4th July weekend?

Looking to take the CISA exam. I have over 5 years of audit experience. How long do you think it’d take to study? Also, what study material should I use? Any good boot camps you’d recommend?

Looking to specialize in privacy and was considering getting the CIPP/CIPM/CIPT. I already have my CISSP and CISA. Is it worth it?

like

EY Interview - Business Consulting - Technology Risk - Senior

Hello All,
I applied and ended up getting an interview for a Business Consulting Technology Risk Senior interview at EY. I have a call with the recruiter tomorrow to discuss opportunities within the service line. Can you please help if anyone has been through this process? What should I expect in the call tomorrow as well as the process? Is it going to be difficult for me to get the job? I really want it!

Thank you.

like

Has anyone participated in the AWS Tech U program. I’m trying to break into solutions architecture and trying to use that. I am a consultant at D and wondering if this is a downgrade. Does anyone know level of the program, structure, pay? Any help appreciated

like

Interviewing for a digital transformation manager role at GT, any tips? Thank u fellow fishes 🤞😊

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal